* CAN YOU PLEASE ANSWER PART TWO AS WELL * * CAN YOU PLEASE ANSWER PART TWO AS WELL * * CAN YOU PLEASE ANSWER PART TWO A

[answerhappygod]

* CAN YOU PLEASE ANSWER PART TWO AS WELL *
* CAN YOU PLEASE ANSWER PART TWO AS WELL *
* CAN YOU PLEASE ANSWER PART TWO AS WELL *
Part1 – Database Design (ifcovered Chapters 2 and 3)
Step 1: Create a set of requirements thatwill be used to create the ER Diagram in Step 2.
Step 2: Create an ER diagram(using ERDPlus) that contains at least five entitiesand at least four binary relationships. At least one of therelationships should be many to many. Show all attributes of allentities.
Step 3: Map the ER diagram you created inStep 2 into a relational schema containing the relations (withtheir attributes) and the referential integrity constraints (i.e.arrows pointing from foreign keys into their sources).Use ERDPlus to draw the mapped relationalschema.
Part2 - Database Implementation (ifcovered Chapter 5 and/or use MS Access)
Step 1: Examine the Relational Schema thatwas created during the Part 1 of the project.
Step 2: Based on that schema, create a setof tables for using a DBMS (such as MS Access, Oracle,PostgreSQL, My SQL or similar). Name the database and itstables appropriately. Make sure to specify primary keys for alltables. Make sure all referential integrity constraints areenforced.
Step 3: Create all the necessaryrelationships between the tables.
Step 4: Populate the tables with initialdata (no less than two no more than ten records per table).
(Optional) Step 5: Create a front-endinterface containing several forms and reports of your choice forthe created database.