MINI -PROJECT TITLE

Student Appointment Management System - using PL/SQL

1. Create minimum of 6 tables
2. ER - Diagram
3. Insert the values
4. Delete the values
5. Update the values
6. Drop the values
7. Modify the values
8. View the tables

MINI PROJECT requirements:

1. The databases must include minimum of 6 tables.
2. Use of Constraints and Managing Concurrency Control,
3. Deadlock and Distributed Systems.
4. Explain clearly design elements of the database.
5. Perform all operations like Insert delete, Access data by applying joins using PL/SQL programs.( Declare begin end)
6. Prepare project document Report and also prepare PowerPoint presentation.
7. Total marks:15 [ 10 Documents + 5 Presentation]

System Design: Phases of database design :

• Requirements collection and analysis
• Conceptual data model design
• Logical data model design
• Physical data model design
• Implementation using PL/SQL

MINI -PROJECT TITLE Student Appointment Management System - using PL/SQL 1. Create minimum of 6 tables 2. ER - Diagram 3. Insert the values 4. Delete the values 5. Update the values 6. Drop the values 7. Modify the values 8. View the tables MINI PROJECT requirements: 1. The databases must include minimum of 6 tables. 2. Use of Constraints and Managing Concurrency Control, 3. Deadlock and Distributed Systems. 4. Explain clearly design elements of the database. 5. Perform all operations like Insert delete, Access data by applying joins using PL/SQL programs.( Declare begin end) 6. Prepare project document Report and also prepare PowerPoint presentation. 7. Total marks:15 [ 10 Documents + 5 Presentation] System Design: Phases of database design: Requirements collection and analysis Conceptual data model design Logical data model design Physical data model design Implementation using PL/SQL MINI -PROJECT TITLE Student Appointment Management System - using PL/SQL 1. Create minimum of 6 tables 2. ER - Diagram 3. Insert the values 4. Delete the values 5. Update the values 6. Drop the values 7. Modify the values 8. View the tables MINI PROJECT requirements: 1. The databases must include minimum of 6 tables. 2. Use of Constraints and Managing Concurrency Control, 3. Deadlock and Distributed Systems. 4. Explain clearly design elements of the database. 5. Perform all operations like Insert delete, Access data by applying joins using PL/SQL programs.( Declare begin end) 6. Prepare project document Report and also prepare PowerPoint presentation. 7. Total marks:15 [ 10 Documents + 5 Presentation] System Design: Phases of database design: Requirements collection and analysis Conceptual data model design Logical data model design Physical data model design Implementation using PL/SQL