PROGRAM CORE

Course Code Course Title L T P S C

22CA202007 CLOUD COMPUTING 3 - 2 - 4

Pre-Requisite -

Anti-Requisite -

Co-Requisite -

COURSE DESCRIPTION: This Course provides a detailed discussion on Virtualization, Cloud

Computing Fundamentals along with Deployment Models. Able to understand Cloud Computing
Architecture to work with Cloud adopting Cloud Computing Mechanisms and implementing
Cloud Security Mechanisms in Cloud Service Models.
COURSE OUTCOMES: After successful completion of the course, students will be able to:

CO1. Demonstrate the concepts of Cloud Computing, Cloud-Enabling Technology, Cloud

Architectures.

CO2. Apply virtualization and develop virtual environments for the deployment of cloud
applications.

CO3. Design applications using cloud service models salesforce.com (SaaS), Google App
Engine (PaaS), Amazon (IaaS) and deploy in cloud.

CO4. Identify and analyze the Cloud-Enabling Technologies and architectures for developing
the applications to solve e-commerce problems.

CO5. Adhere to ethics and adapt cloud security mechanisms and Cloud-Based Security
Groups for providing security to societal applications.

CO-PO-PSO Mapping Table:

Program Specific
Course Program Outcomes
Outcomes
Outcomes
PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8 PO9 PO10 PO11 PO12 PSO1 PSO2 PSO3 PSO4

CO1 3 3 2 - - - - - - - - - - 3 3 -

CO2 3 3 3 - 3 - - - - - - 3 3 -

CO3 3 3 - - 3 - - - - - - 3 3 -

CO4 2 3 3 - 3 - - - - - - 3 3 -

CO5 - - - - - - - - - - 3 - - - - -

Course
Correlation 3 3 3 - 3 - - - 3 - 3 - - 3 3 -
Mapping

Correlation Levels: 3: High; 2: Medium; 1: Low

COURSE CONTENT

Module 1: FUNDAMENTAL CLOUD COMPUTING (10 Periods)

Understanding Cloud Computing: Origins and Influences, Concepts and Terminology,
Goals and Benefits, Risks and Challenges.
Fundamental Concepts and Models: Roles and Boundaries, Cloud Characteristics, Cloud
Delivery Models, Cloud Deployment Models.

Module 2: CLOUD COMPUTING MECHANISMS AND ARCHITECTURE (11 Periods)

Cloud-Enabling Technology: Broadband Networks and Internet Architecture, Data Center
Technology, Virtualization Technology, Web Technology, Multitenant Technology, Service
Technology.
Fundamental Cloud Architectures: Workload Distribution, Resource Pooling, Dynamic
Scalability, Elastic Resource Capacity, Service Load Balancing, Cloud Bursting, Elastic Disk
Provisioning, Redundant Storage.

Module 3: CLOUD COMPUTING ADVANCED ARCHITECTURES (12 Periods)

Advanced Cloud Architectures: Hypervisor Clustering, Load Balanced Virtual Server
Instances, Non Disruptive Service Relocation, Zero Downtime, Cloud Balancing, Resource
Reservation, Dynamic Failure Detection and Recovery, Bare-Metal Provisioning, Rapid
Provisioning, Storage Workload Management.
Specialized Cloud Architectures: Direct I/O Access, Direct LUN Access, Dynamic Data
Normalization, Elastic Network Capacity, Cross-Storage Device Vertical Tiering, Intra Storage
Device Vertical Data Tiering, Load Balanced Virtual Switches, Multipath Resource Access,
Persistent Virtual Network Configuration, Redundant Physical Connection for Virtual Servers,
Storage Maintenance Window.

Module 4: CLOUD SECURITY (11 Periods)

Fundamental Cloud Security: Threat Agents, Cloud Security Threats, Additional
Considerations, Case Study Example.
Cloud Security Mechanisms: Encryption, Hashing, Digital Signature, Public Key Infrastructure,
Identity and Access Management, Single Sign-On, Cloud-Based Security Groups, Hardened
Virtual Server Images.

Module 5: CLOUD SERVICE MODELS (11 Periods)

Cloud Service Models: Software as a Service (SaaS) - Characteristics, Examples and
Applications. Platform as a Service (PaaS) - Characteristics, Examples and Applications.
Infrastructure as a Service (IaaS) - Characteristics, Examples and Applications.
Case Study: SaaS: Salesforce.com, Facebook.com; PaaS: Google App Engine, MS-Azure and
IBM Bluemix; IaaS: Amazon EC2, Amazon S3 and Netflix.
Total Periods: 45

EXPERIENTIAL LEARNING

1. Create a word document of your class time table and store locally and on the cloud with
doc, and pdf format.
2. Create a spread sheet which contains employee salary information and calculate gross
and total sal using the formula DA=10% OF BASIC HRA=30% OF BASIC PF=10% OF BASIC
IF BASIC<=3000 12% OF BASIC IF BASIC>3000 TAX=10% OF BASIC IF BASIC<=1500
=11% OF BASIC IF BASIC>1500 AND BASIC<=2500 =12% OF BASIC IF BASIC>2500
 NET_SALARY=BASIC_SALARY+DA+HRA-PF-TAX.
3. Prepare a ppt on cloud computing – Introduction, models, services, and Architectures.
PPTs should contain explanations, images and at least 20 slides
4. Create your resume in a neat format using google cloud Programs on PaaS.
5. Create an EC2 instance and invoke Ubuntu operating system with a given set of
configuration on amazon web services under IaaS.
6. Create S3 bucket and store a file in it using AWS.
7. Configure web server on Amazon Linux instance with ElasticIP.
8. Develop a web application which contains employee salary information and calculate
gross and total sal using the formula DA=10% OF BASIC HRA=30% OF BASIC PF=10% OF
BASIC IF BASIC<=3000 12% OF BASIC IF BASIC>3000 TAX=10% OF BASIC IF
BASIC<=1500 =11% OF BASIC IF BASIC>1500 AND BASIC<=2500 =12% OF BASIC IF
BASIC>2500 NET_SALARY=BASIC_SALARY+DA+HRA-PF-TAX.
9. Generating reports in Salesforce admin.
10. Process of User Management in Salesforce admin.
11. Procedure of Data Management in Salesforce admin.
12. Procedure of providing data security using control access to data using point and click
tools in Salesforce admin.

RESOURCES

TEXT BOOKS:
1. Thomas Erl, Zaigham Mahmood, and Ricardo Puttini “Cloud Computing- Concepts,
Technology & Architecture,” Pearson Publication, 2014.
2. Barrie Sosinsky, “Cloud Computing Bible”, Wiley India Pvt. Ltd, 2011.
3. George Reese “Cloud Application Architectures,” O’Reilly Publications, 2009.

REFERENCE BOOKS:
1. Thomas Erl and Ricardo Puttini “Cloud Computing- Concepts, Technology & Architecture,”
Pearson, 2013.
2. John W. Rittinghouse, James F. Ransome, “Cloud Computing implementation, Management
and Security,” CRC Press, ISBN: 9788120341609, Taylor & Francis group, 2010.

3. Barrie Sosinsky, “Cloud Computing Bible,” Wiley India Pvt Ltd, 2011.

4. Rajkumar Buyya, James Broberg and Andrzej Goscinski, “Cloud computing principles and
paradigms”, John Wiley and Sons, 2011.

SOFTWARE/TOOLS:
1. Google App Engine
2. Amazon Web Services
3. Sales Force
VIDEO LECTURES:
1. https://youtu.be/uroryFU78gM
2. https://youtu.be/Pg5nj90xh68
3. https://youtu.be/2Dd2ducs-ic
4. https://youtu.be/Ijkvx1u0w6o
5. https://youtu.be/sMlOsYBMRag

Web Resources:
1. www.salesforce tutorial.com
2. Htpps:// trailhead.salesforce.com/en/home
3. https://MKyong.com/tutorials/google-App- engine-tutorial/
4. https://aws.amazon.com

PROGRAM CORE

Course Code Course Title L T P S C

 22CA202003 DATABASE MANAGEMENT SYSTEMS 3 - 2 - 4

Pre-Requisite -

Anti-Requisite -

Co-Requisite -
COURSE DESCRIPTION: This Course provides theoretical concepts and hands-on experience
on Database systems, Database design, Relational model, Relational algebra, SQL queries,
Constraints and triggers, PL/SQL, Schema refinement and normal forms, Transaction
management, Concurrency control, Overview of storage and indexing.

COURSE OUTCOMES: After successful completion of the course, students will be able to:
CO1. Analyze and apply the concepts of ER-modeling and normalization to design viable data
models for a given problem.
CO2. Formulate relational database schemas, apply suitable integrity constraints, for
querying databases.
CO3. Use SQL to store, query, and manipulate data in relational databases.
CO4. Develop PL/SQL blocks to centralize database applications for maintainability
and reusability.
CO5. Analyze transaction processing, concurrency control and storage methods for
database management.
CO6. Work Independently and Communicate Effectively in Oral and Written forms.

CO-PO-PSO Mapping Table:

Program Specific
Program Outcomes
Course Outcomes
Outcomes PO1 PO1 PO1 PSO PSO PSO PSO
PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8 PO9
0 1 2 1 2 3 4

CO1 2 2 3 - - - - - - - - - 2 - 3 -

CO2 1 3 2 2 3 - - - - - - - 2 - 3 -

CO3 1 2 3 2 3 - - - - - - - 2 - 3 -

CO4 2 3 3 3 3 2 - - - - - - 3 - 2 -

CO5 3 3 - - - - - - - - - - 2 - 3 -

CO6 - - - - - - - - 3 3 - - - - - -
Course
Correlat
2 3 3 2 3 2 - - 3 3 - - 2 - 3 -
ion
Mapping

Correlation Levels: 3: High; 2: Medium; 1: Low

COURSE CONTENT

Module 1: INTRODUCTION TO DATABASE SYSTEMS AND DATABASE (08 Periods)

DESIGN
Introduction to Database Systems: Database system applications, Purpose of database
systems, View of data - Data abstraction, Instances and schemas, Data models; Database languages
- Data Definition Language, Data Manipulation Language; Database architecture, Database users
and administrators.
Introduction to Database Design: Database design and ER diagrams, Entities, attributes and
entity sets, Relationships and relationship sets, Additional features of ER model, Conceptual Design
with ER model.

Module 2: RELATIONAL MODEL AND RELATIONAL ALGEBRA (08 Periods)

Relational Model: ting and modifying relations, Integrity constraints over relations, Enforcing
integrity constraints, Querying relational data, Logical database design, Introduction to views,
Destroying/altering tables and views.
Relational Algebra: Preliminaries, Relational Algebra operators.

Module 3: SQL AND PL/SQL (10 Periods)

SQL: Form of basic SQL query, Nested queries, Aggregate operators, Null values, Complex integrity
constraints in SQL, Triggers and active databases.
PL/SQL: Generic PL/SQL block, PL/SQL data types, Control structure, Procedures and functions,
Cursors, Database triggers.

Module 4: SCHEMA REFINEMENT AND TRANSACTIONS (10 Periods)

Schema Refinement: Problems caused by redundancy, Decompositions, Problems related to
decomposition, Functional dependencies, Reasoning about FDs, First normal form, Second normal
form, Third normal form, Boyce-Codd normal form, Multivalued dependencies, Fourth normal form,
Join dependencies, Fifth normal form.
Transactions: Transaction concept, Transaction atomicity and durability, Concurrent Executions –
Serializability, Recoverability, Implementation of isolation, Testing for serializability.

Module 5: CONCURRENCY CONTROL, STORAGE AND INDEXING (09 Periods)

Concurrency Control: Lock Based Protocols, Timestamp Based Protocols, Validation Based
Protocols, Multiple Granularity, Deadlock Handling.
Storage and Indexing: Data on external storage, File organizations and indexing – Clustered
indexes, Primary and secondary indexes; Index data structures – Hash based indexing, Tree based
indexing; Comparison of file organizations.
Total Periods: 45
 EXPERIENTIAL LEARNING

1) Design and analyze an ER-Model for the following use case.

Road way Travels is in business since1977 with several buses connecting different
places in India. Its main office is in Hyderabad. The company wants to computerize
its operations in the following areas:
a) Reservations
b) Ticketing
c) Cancellations

Reservations:
Reservations are directly handled by booking office. Reservations can be made 60
days in advance in either cash or credit. In case the ticket is not available, await listed
ticket is issued to the customer. This ticket is confirmed against the cancellation.

Cancellation and Modification:

Cancellations are also directly handed at the booking office. Cancellation charges will
be charged. Wait listed tickets that do not get confirmed are fully refunded.

2) a) Implement Single Row functions-Character, Numeric and Date functions.

b) Implement Data Definition Language commands-Create, Alter, Drop, Truncate,

and Rename.

c) Implement Data Manipulation Language commands-Insert, Select, Update, and

Delete.

3) Implement various types of integrity constraints-NOT NULL constraint, DEFAULT

constraint, UNIQUE constraint, PRIMARY key, FOREIGN key, CHECK constraint.

4) a) Implement group functions with different operators such as aggregate operators,

group by, having and order by.

b) Implement nested and correlated nested queries using set operators and set
comparison operators.

5) a) Creation of views, synonyms, sequence, indexes and save point

b) Implement various types of joins-outer join and inner join.

Basic PL/SQL:

6) Construct PL/SQL block for the following:

a) To determine whether a number is palindrome

b) To determine whether a number is an Armstrong number

c) To find greatest of three numbers

d) To display Fibonacci series

Control Structures:

7) a) Write a programming PL/SQL to update the salary of a specific employee by 8%

if the salary exceeds the mid-range of the salary against this job and update up
to mid-range if the salary is less than the mid-range of the salary, and display a
suitable message.

b) Write a PL/SQL program to display the description against a student‘s grade

using CASE statement.

Exception Handling:

8) a) Develop a PL/SQL program that displays the name and address of a student
whose ID is given. If there is no student with the given student ID in the
database, the program should raise a run-time exception NO_DATA_FOUND,
which should be captured in the EXCEPTION block.

b) Construct the user-defined exceptions to get the salary of an employee and

check it with the job‘s salary range. If the salary is below the range, raise an
exception BELOW_SALARY_RANGE. If his salary is above the range, raise the
exception ABOVE_SALARY_RANGE.

Functions:

9) a) Write a function that accepts two numbers A and B and performs the following
operations.
o Addition
o Subtraction
o Multiplication
o Division

b) Write a PL/SQL block that updates salary of an employee in Employee table by

using incr function which takes employee number as argument and calculates
increment and returns increment based on the following criteria.
o If salary<=3000, increment=30%ofsalary
o If salary > 3000 and <= 6000, increment = 20% of salary
o Else increment = 10% of salary

Procedures:

10) a) Write a procedure that accepts two numbers and displays their sum

b) Write procedures to demonstrate IN, INOUT and OUT parameters

Cursors:

11) a) Write a block in PL/SQL to create a Cursor that displays the employee name
and number of jobs he/she has done in the past.

b) Write a program in PL/SQL to create a cursor to display the name and salary of each
employee in the EMPLOYEES table whose salary is less than that’ specified by a
 passed-in parameter value.

Triggers:

12) Develop a suitable student database application by considering appropriate

attributes. Couple of attributes to be maintained is the attendance of a student in
each subject for which he/she has enrolled and internal assessment Using TRIGGERS
for the following:

a) Whenever the attendance is updated, check if the attendance is less than 85%;if
so, notify the concerned head of the department.

b) Whenever, the marks in an internal assessment test are entered, check if the
marks are less than 40%; if so, notify the concerned head of the department.

RESOURCES
TEXT BOOKS:

1. Raghu Ramakrishnan, Johannes Gehrke, Database Management Systems, McGrawHill, 3 rd

Edition, 2014.
2. Abraham Silberschatz, Henry. F. Korth, S. Sudarshan, Database System Concepts,
McGrawHill, 7th edition, 2019.
REFERENCE BOOKS:

1. Ivan Bayross, SQL, PL/SQL: The Programming Language of Oracle, BPB publications, 4 th
Edition, 2017.
2. Ramez Elmasri, Shamkant B. Navathe, Fundamentals of Database Systems, 7 th Edition,
Pearson, 2015.
3. Thomas Connolly, Carolyn Begg, Database Systems, Pearson, 6 th edition, 2019.

4. S.K.Singh, Database System Concepts, Design and Applications, 1st Edition, Pearson
Education, 2006.
5. SatishAnsani, Oracle Database 11g: Hands-on SQL and PL/SQL, PHI, 2010.

6. Dr. Rajiv Chopra, Database Management Systems, Sultan Chand, 2016.

7. Pranab Kumar Das Gupta, P. Radha Krishna, Database Management System Oracle SQL
and PL/SQL, PHI, 2nd Edition, 2009.

VIDEO LECTURES:
1. https://swayam.gov.in/nd1_noc19_cs46/preview
2. https://nptel.ac.in/courses/106105175
3. https://onlinecourses.nptel.ac.in/noc21_cs04/preview
4. https://www.youtube.com/watch?v=MDQxqYVXiVU
5. https://www.youtube.com/watch?v=c5HAwKX-suM

WEB RESOURCES:

1. https://www.classcentral.com/course/swayam-introduction-to-database-systems-17660
2. https://www.scaler.com/topics/dbms/
3. https://www.academia.edu/27988617/Database_Management_System_DBMS_Tutorial
4. https://nptel.ac.in/courses/106104135
5. https://downloads.mysql.com/docs/mysql-tutorial-excerpt-5.7-en.pdf
6. https://docs.oracle.com/cd/E11882_01/server.112/e40540/intro.htm#CNCPT88786