Question

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

          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

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

Added by Heidi P.

Question

Please give Ace some feedback