MINI PROJECT requirements and steps:

The databases must include minimum of $6$ tables.

Design a Database showcasing your skills on building relationship between tables,

Apply Joins,Alter,Update,Group by$,$SET operators

Use of Constraints$($Integrity Constraints$-$Primary key, NOT Null, Default,Referential $,$Check$)$ and

Managing Concurrency Control,Deadlock and Distributed Systems.

Explain clearly design elements of the database.

Perform all operations like Insert delete, Access data by applying joins using $P\frac{L}{S}OL$ programs. $($Declare$,$ Procedures and Functions, Cursors and Triggers$)$

Prepare project document Report and also prepare PowerPoint presentation.

Total marks:$20[15$ Project Document Report $+5$ Presentation$]$

System Design: Phases of database design :

Requirements collection and analysis $(2$ Mark$)$

Conceptual data model design $(2$ Marks$)$

Logical data model design $(2$ Marks$)$

Physical data model design $(2$ Marks$)$

Implementation using PL$/$SOL$-$declare begin end $,$Procedures. Functions, Cursors and Triggers.

$(7$ marks$)$