File Organization and Database Systems Lab (MA39204)

L-T-P: 0-0-3   |   Credits: 2

Syllabus

Conceptual Design

• ER Diagrams: Identify entities, attributes, keys, relationships, cardinalities, generalization, and specialization.
• ER to Relational Model Conversion:
  • Represent entities and relationships in tabular form.
  • Represent attributes as columns.
  • Identify keys.

Normalization

• Eliminate redundancies and anomalies.
• Normalize up to Third Normal Form (3NF).

SQL Operations

• Database Creation: Write SQL queries to:
  • Retrieve information.
  • Perform Insert, Delete, Modify, Alter, Update, and View operations.
• Create Views, Synonyms, Sequences, Indexes, and Save Points.

Advanced Database Concepts

• Employee Database: Set constraints and establish relationships between databases.
• Study and implement:
  • PL/SQL Block: Satisfy conditions, accept user input, and handle exceptions.
  • Procedures: Create database triggers and functions.

Mini Project

Application development using Oracle/MySQL on one of the following topics:

1. Timetable Management System
2. Hall Management System
3. Web-Based User Identification System
4. Hospital Management System
5. Railway Reservation System
6. Inventory Control System

References

1. H. F. Korth and A. Silberschatz: Database System Concepts, McGraw Hill, New Delhi, 1997.
2. R. A. Elmasri and S. B. Navathe: Fundamentals of Database Systems, 3rd ed., Addison-Wesley, 1998.
3. R. Ramakrishnan: Database Management Systems, 2nd ed., McGraw Hill, New York, 1999.

How to Use this Repository

Clone this repository:

git clone https://github.com/Samya-S/File-Organization-and-Database-Systems-Lab.git

License

This project is licensed under the MIT License - see the LICENSE file for details.