Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: THEend8_
Database Management Systems (CSC570.001) Database Project (40 Points)
Consider an organization of your choice (e.g., manufacturing company, bank, accounting system, video rental, medical applications, retail store, Online_shopping,…) for which you are assigned to design and develop a database. Note that this is a real world database and therefore all entities, attributes, relationships, and assumptions must be reasonable.
a)-Define a set of entities and appropriate attributes for each entity. Minimum 10 entities.
b)-Define a set of relationships that might exist between/among entities and attributes. Such relationships may include one-to-one, one-to-many and many-to-many associations.
c)-Define a set of constraints that may be imposed on data.
3) – Define a relational schema for your database design.
Make sure that you have both one-to-many and many-to-many associations. a)-Define one or more realistic key(s) for every relation scheme. Use both simple and composite keys.
b)-Define a realistic set of Functional / Multi-Valued Dependencies (when appropriate) for every relation scheme.
C-Check whether your relational schema is in 2NF, 3NF, BCNF, 4NF.
d)-Put your relational schema in the highest normal form that is possible. Note that, every relation scheme should be in a specific normal form in order to have the relational schema in that normal form.
NOTE: Please provide a detailed explanation for every question when appropriate.
4) Implementation: Create your database using Oracle, or MySQL, or… to Perform the following operations.
A) You are required to execute SQL queries that include the following operations. For each query, provide the SQL statements along with the output. For each of the following, try different SQL statements (i.e., using one relation, more than one relations,…).
– Select: