Answer Happy

1. DEFINITION Pick a project topic which is suitable for a database application. (For example: health care systems, inventory control, education, manufacturing, industry specific, etc.) Once you have decided on your topic, prepare a project report which includes the following parts: a. Briefly explain your topic and state member-task responsibilities. b. Design an E-R diagram based on your project topic. There must be at least five strong entities in your diagram. c. Draw a database schema diagram according to your 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 your schema. e. Write 3 different INSERT INTO statements for each of your tables. f. Write 8 different SQL queries with their descriptions for the database you created. You must write the queries based on the specified approaches below: - 2 joins (with conditions) 2 nested queries 2 set operations - 2 aggregate operations (must include joins)