Project description:
Your project must have the following:
1- Brief description about your organization, which
explain the data that need to be stored in the DB.
2- Enhanced Entity Relationship Diagram (EERD)
3- Database Schema
4- Normalization of any form(s) used by your system
• If the system is fake or if there is no forms, then
do the normalize on the database schema (each
table independently)
5- Implementation of the database and all tables using
MySQL
6- Queries of all the following type:
a. Aggregation function
b. Outer join (any one type)
c. Nested query
d. Use CHECK, LIKE, IN, and logical operator
(<,>,>=,.....) (at least two)
e. Link 3 or more tables
f. Use UNION ALL, EXCEPT ALL,
INTERSECT
g. Use GROUP BY, ORDER BY, HAVING (at
least two)
h. Use DISTINCT, ALL, AS