database management systems project
Budget: $10 – $50 USD
I need someone to pick a project topic which is suitable for a database application. (For example: health care systems, inventory control, education, manufacturing, industry specific, etc.) *We'll discuss that in PM)
and make a project report which includes the following parts:
a. Briefly explain the topic.
b. Design an E-R diagram based on the project topic. (There must be at least five strong entities in the diagram).
c. Draw a database scheme diagram according to the E-R design. Show that every relation satisfies at least Boyce-Codd normal form.
d. Write necessary CREATE TABLE statements (including constraint definitions) for all relations in the schema.
e. Write 3 different INSERT INTO statements for each of the tables.
f. Write 8 different SQL queries with their descriptions for the database created. Must write the queries based on the specified approaches below:-
-2joins(with conditions)
-2nested queries
-2set operations
-2aggregate operations (must include joins).
I need the PDF file ready by tomorrow before 9PM (+3 GMT)
and make a project report which includes the following parts:
a. Briefly explain the topic.
b. Design an E-R diagram based on the project topic. (There must be at least five strong entities in the diagram).
c. Draw a database scheme diagram according to the E-R design. Show that every relation satisfies at least Boyce-Codd normal form.
d. Write necessary CREATE TABLE statements (including constraint definitions) for all relations in the schema.
e. Write 3 different INSERT INTO statements for each of the tables.
f. Write 8 different SQL queries with their descriptions for the database created. Must write the queries based on the specified approaches below:-
-2joins(with conditions)
-2nested queries
-2set operations
-2aggregate operations (must include joins).
I need the PDF file ready by tomorrow before 9PM (+3 GMT)