data base

1- System’s Description
Revise and refine the following (from your initial report):
• The problem description of your system
• Data requirements
• The business rules of your system
Furthermore, provide the following details:
• What are the outputs of your system? What are the queries, reports, calculations which
your system will provide to its users? Be comprehensive and concise.
2- ER Diagram
Given the detailed problem description, data requirements, and business rules of your
system, draw the conceptual ER or EER schema model.
Illustrate on the diagram each entity type, relationship, cardinality ratio, and participation
constraints (total or partial) of entities in relationships.
3- Design Justification
Show how the business rules which you have stated has affected your design decisions.
4- ER-to-Relational Mapping
Map the ER or EER diagram into a Relational database schema diagram. Follow the steps of
the algorithm in Chapter 9. Illustrate the following on the schema diagram:
• Table names
• Referential integrity constraints
• Primary keys and Foreign keys