DBMS LAB
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:
- Knowledge of Computer architecture and organization,
- Knowledge of microprocessor
- Knowledge of C programming language
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
Hardware and Software requirements
Hardware :
| Computer Systems | 60/30 |
| RAM | 1 GB |
| PROCESSOR | INTEL PENTIUM 915 GV |
| HARD DISK | 160 GB |
Software’s
ORACLE 8i,9i. MY SQL, DB2.