[admission-open-date]
- Back to School Homepage
- Back to Department Homepage
CS07 – Introduction to Database Management System
Theory: 45 hours
Prerequisite: Basic knowledge of Computer
Modules
Unit 1:
- Data, Database, Database management system(DBMS), Characteristics of the database approach, Role of Database administrators, Role of Database Designers, End Users, Types of DBMS, Applications of DBMS, Advantages of Using a DBMS and When not to use a DBMS .
-
7 hours
Unit 2 :
- Data Models – Categories of data models, Schemas, Instances, and Database state. DBMS Architecture and Data Independence – The Three schema architecture, Data independence. DBMS Languages and Interfaces.
-
7 hours
Unit 3:
- Using High Level Conceptual Data Models for Database Design, Example Database applications. Entity types, Entity Sets, Attributes and Keys. Relationships, Relationship types, Weak Entity Types and Drawing E-R Diagrams.
-
7 hours
Unit 4:
- Relation, Integrity constraints – domain, entity and Referential integrity constraints, Basic Relational Algebra operations, select, project and join operations. Functional dependencies and Normalization for Relational Databases – Normalization concepts, first, second, third normal forms, Boyce-Codd normal form.
-
9 hours
Unit 5:
- Queries, sub queries, correlated sub query, views, updation of a database through views, Update, Delete. Hands on Experience.
-
15 hours
-
Text Book
-
Elmasri & Navathe, Fundamentals of Database Systems,2nd Edition, Addison – Wesley
-
Reference
-
O`neil Patric & O`neil Elizabeth, Database Principles, Programming and Performance, 2nd Edition, Margon Kaufmann Publishers Inc. -
Silberschatz, Korth, Sudarshan, “Database System Concepts”, 4th Edition, Mc Graw Hill
C Programming Lab
Guidelines
Article
Follow Coding standards
Article I
The output of the programs should be neatly formatted
Article II
The programs should be user friendly and interactive
Article III
Use comment wherever necessary
Lab Programs
-
Demonstrate cal, date, echo and bc commands -
Demonstrate passwd, who, uname and tty commands -
Demonstrate all Directory related commands -
Demonstrate all file related commands -
Demonstrate all File compression commands -
Demonstrate all Communication commands -
Write a shell script to accept 2 numbers and perform the basic arithmetic operation -
Write a shell script to accept any N numbers and find the sum of N numbers using function -
Write a shell script to print current working directory, today’s date and number of users who are currently logged in. -
Write a shell script to implement various if statements.
Admission Queries
For any queries at any given time during the application and admission process, you may contact us through the following Email ID’s:
Bangalore Central Campus
The Office of Admissions,CHRIST (Deemed to be University), Hosur Road,Bengaluru – 560 029, Karnataka, INDIA
Phone
+91 92430 80800
+91 80 4012 9400
Email IDs
Indian candidates: admissions@christuniversity.in
NRI candidates: nri.admission@christuniversity.in
International: isc.admission@christuniversity.in
Bangalore Kengeri Campus
CHRIST (Deemed to be University)
Kanmanike, Kumbalgodu, Mysore Road,
Bengaluru – 560 074, Karnataka, INDIA
Delhi NCR Campus
CHRIST (Deemed to be University),
Mariam Nagar, Meerut Road,
Delhi NCR Ghaziabad – 201003
Phone
1800-123-3212
Bangalore Bannerghatta Road Campus
CHRIST (Deemed to be University)
Hulimavu, Bannerghatta Road,
Bengaluru – 560 076, Karnataka, INDIA
Phone
+91 080 4655 1306
Email
admissions.bgr@christuniversity.in
Bangalore Yeshwanthpur Campus
CHRIST (Deemed to be University)
Nagasandra, Near Tumkur Road,
Bengaluru 560 073, Karnataka, INDIA
Pune Lavasa Campus
CHRIST (Deemed to be University),
Christ University Road, 30 Valor Court, PO Dasve Lavasa, Mulshi, Pune – 412112, Maharashtra
Phone
1800-123-2009
Between: Monday to Friday: 09:00 AM to 04:00 PM,
Saturday: 09:00 AM to 12:00 PM
(Office remains closed on Sundays, Government Holidays and Any special events)
CS07 – Introduction to Database Management System
Theory: 45 hours
Prerequisite: Basic knowledge of Computer
Modules
Unit 1:
- Data, Database, Database management system(DBMS), Characteristics of the database approach, Role of Database administrators, Role of Database Designers, End Users, Types of DBMS, Applications of DBMS, Advantages of Using a DBMS and When not to use a DBMS .
-
7 hours
Unit 2 :
- Data Models – Categories of data models, Schemas, Instances, and Database state. DBMS Architecture and Data Independence – The Three schema architecture, Data independence. DBMS Languages and Interfaces.
-
7 hours
Unit 3:
- Using High Level Conceptual Data Models for Database Design, Example Database applications. Entity types, Entity Sets, Attributes and Keys. Relationships, Relationship types, Weak Entity Types and Drawing E-R Diagrams.
-
7 hours
Unit 4:
- Relation, Integrity constraints – domain, entity and Referential integrity constraints, Basic Relational Algebra operations, select, project and join operations. Functional dependencies and Normalization for Relational Databases – Normalization concepts, first, second, third normal forms, Boyce-Codd normal form.
-
9 hours
Unit 5:
- Queries, sub queries, correlated sub query, views, updation of a database through views, Update, Delete. Hands on Experience.
-
15 hours
Unit 1:
- Data, Database, Database management system(DBMS), Characteristics of the database approach, Role of Database administrators, Role of Database Designers, End Users, Types of DBMS, Applications of DBMS, Advantages of Using a DBMS and When not to use a DBMS .
-
7 hours
Unit 2 :
- Data Models – Categories of data models, Schemas, Instances, and Database state. DBMS Architecture and Data Independence – The Three schema architecture, Data independence. DBMS Languages and Interfaces.
-
7 hours
Unit 3:
- Using High Level Conceptual Data Models for Database Design, Example Database applications. Entity types, Entity Sets, Attributes and Keys. Relationships, Relationship types, Weak Entity Types and Drawing E-R Diagrams.
-
7 hours
Unit 4:
- Relation, Integrity constraints – domain, entity and Referential integrity constraints, Basic Relational Algebra operations, select, project and join operations. Functional dependencies and Normalization for Relational Databases – Normalization concepts, first, second, third normal forms, Boyce-Codd normal form.
-
9 hours
Unit 5:
- Queries, sub queries, correlated sub query, views, updation of a database through views, Update, Delete. Hands on Experience.
-
15 hours
-
Text Book
-
Elmasri & Navathe, Fundamentals of Database Systems,2nd Edition, Addison – Wesley
-
Reference
-
O`neil Patric & O`neil Elizabeth, Database Principles, Programming and Performance, 2nd Edition, Margon Kaufmann Publishers Inc. -
Silberschatz, Korth, Sudarshan, “Database System Concepts”, 4th Edition, Mc Graw Hill
C Programming Lab
Guidelines
Article
Follow Coding standards
Article I
The output of the programs should be neatly formatted
Article II
The programs should be user friendly and interactive
Article III
Use comment wherever necessary
Lab Programs
-
Demonstrate cal, date, echo and bc commands -
Demonstrate passwd, who, uname and tty commands -
Demonstrate all Directory related commands -
Demonstrate all file related commands -
Demonstrate all File compression commands -
Demonstrate all Communication commands -
Write a shell script to accept 2 numbers and perform the basic arithmetic operation -
Write a shell script to accept any N numbers and find the sum of N numbers using function -
Write a shell script to print current working directory, today’s date and number of users who are currently logged in. -
Write a shell script to implement various if statements.
Admission Queries
For any queries at any given time during the application and admission process, you may contact us through the following Email ID’s:
Bangalore Central Campus
The Office of Admissions,CHRIST (Deemed to be University), Hosur Road,Bengaluru – 560 029, Karnataka, INDIA
Phone
+91 92430 80800
+91 80 4012 9400
Email IDs
Indian candidates: admissions@christuniversity.in
NRI candidates: nri.admission@christuniversity.in
International: isc.admission@christuniversity.in
Bangalore Kengeri Campus
CHRIST (Deemed to be University)
Kanmanike, Kumbalgodu, Mysore Road,
Bengaluru – 560 074, Karnataka, INDIA
Delhi NCR Campus
CHRIST (Deemed to be University),
Mariam Nagar, Meerut Road,
Delhi NCR Ghaziabad – 201003
Phone
1800-123-3212
The Office of Admissions,CHRIST (Deemed to be University), Hosur Road,Bengaluru – 560 029, Karnataka, INDIA
Phone
+91 92430 80800
+91 80 4012 9400
Email IDs
Indian candidates: admissions@christuniversity.in
NRI candidates: nri.admission@christuniversity.in
International: isc.admission@christuniversity.in
CHRIST (Deemed to be University)
Kanmanike, Kumbalgodu, Mysore Road,
Bengaluru – 560 074, Karnataka, INDIA
Phone
+91 80 4012 9800,
+91 80 4012 9802
+91 80 4012 9820
Email
admissions.kengeri@christuniversity.in
CHRIST (Deemed to be University),
Mariam Nagar, Meerut Road,
Delhi NCR Ghaziabad – 201003
Phone
1800-123-3212
Email
admission.ncr@christuniversity.in
Bangalore Bannerghatta Road Campus
CHRIST (Deemed to be University)
Hulimavu, Bannerghatta Road,
Bengaluru – 560 076, Karnataka, INDIA
Phone
+91 080 4655 1306
Email
admissions.bgr@christuniversity.in
Bangalore Yeshwanthpur Campus
CHRIST (Deemed to be University)
Nagasandra, Near Tumkur Road,
Bengaluru 560 073, Karnataka, INDIA
Pune Lavasa Campus
CHRIST (Deemed to be University),
Christ University Road, 30 Valor Court, PO Dasve Lavasa, Mulshi, Pune – 412112, Maharashtra
Phone
1800-123-2009
CHRIST (Deemed to be University)
Hulimavu, Bannerghatta Road,
Bengaluru – 560 076, Karnataka, INDIA
Phone
+91 080 4655 1306
Email
admissions.bgr@christuniversity.in
CHRIST (Deemed to be University)
Nagasandra, Near Tumkur Road,
Bengaluru 560 073, Karnataka, INDIA
Phone
+91 97422 44407
+91 80 6989 6666
Email
admissions.yeshwanthpur@christuniversity.in
CHRIST (Deemed to be University),
Christ University Road, 30 Valor Court, PO Dasve Lavasa, Mulshi, Pune – 412112, Maharashtra
Phone
1800-123-2009
Email
admission.lavasa@christuniversity.in
Between: Monday to Friday: 09:00 AM to 04:00 PM,
Saturday: 09:00 AM to 12:00 PM
(Office remains closed on Sundays, Government Holidays and Any special events)