SUBJECT-DATABASE

prepare a PowerPoint recorded video presentation (max. time 12-15 min.), to be submitted.

1. Introduction of Business

Students are free to choose Business according to their area of interest.(Business=school based)

a. Objective of the business.

b. List of Entities (min. of 5 for a student-based or groups, comprised of two students and a

min. of 9 entities for groups, comprised of 3 or 4 students) involved. Table with Attribute and Behaviour. Reasonable number of attributes, showing relevant constraints will be evaluated.

2. Develop the entity relationship diagram level 1

3. Develop the entity relationship diagram level 2

4. Demonstrate that the database is Boyce-Codd normalized (BCNF)

5. Design SQL queries stating conditions and joins.

6. Demonstrate the characteristics of your database. Integrity etc.

7. Suggest Data analytics from the database.

8. Learning from the project.

9. Scope of Improvement.

10. References.