Objectives of the course
To understand the different issues involved in the design and implementation of a
database system.
To study the physical and logical database designs, database modeling, relational,
hierarchical, and network models
To understand and use data manipulation language to query, update, and manage a
database
To develop an understanding of essential DBMS concepts such as: database security,
integrity, concurrency, distributed database, and intelligent database, client/server
(Database Server), data warehousing.
To design and build a simple database system and demonstrate competence with
the fundamental tasks involved with modeling, designing, and implementing a
DBMS.
Outcome:
CO1: It makes students able to learn different types of database system.
CO2: It provides students the knowledge of how to create a database and how to handle those databases.
CO3: At the end of the course, students will be able to implement various management systems so that they can understand the need of database.
CO4: Student can learn the basic concepts of DBMS.
CO5: Student can know the concepts of SQL To understand PL/SQL.
CO6: Student can know triggers and cursors To know the concept of Normalization.
Prerequisites:
References:
Books: “Database System Concepts”, 6th Edition by Abraham Silberschatz, Henry F.
Korth, S. Sudarshan, McGraw-Hill.
1 “Principles of Database and Knowledge – Base Systems”, Vol 1 by J. D. Ullman,
Computer Science Press.
2 “Fundamentals of Database Systems”, 5th Edition by R. Elmasri and S. Navathe,
Pearson Education
3 “Foundations of Databases”, Reprint by Serge Abiteboul, Richard Hull, Victor
Vianu, Addison-Wesley
9.Hardware and Software requirements
Hardware
Software’s
ORACLE 8i,9i. MY SQL, DB2.
