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

 

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

  • Computer Systems   : 60/30
  • RAM                            : 1 GB
  • PROCESSOR             : INTEL PENTIUM 915 GV
  • HARD DISK              : 160 GB

Software’s

ORACLE 8i,9i. MY SQL, DB2.