Database Design (Access) MIS:
Assume that you are creating a database for a company or a department of a company.
1. Create a document that describes your business (e.g., company name, associations among entities or business process, and other things that may affect your database design) and the goals of this business project (the improvements that your business tries to achieve through the database).
2. Provide attributes for the entities in your ERD.
3. Create a data dictionary for your database.
4. Draw an entity relationship diagram.
5. If you have a Many-to-Many relationship, you need to create an associative entity (bridge entity) that can link both original entities.
6. Convert your ERD into relations (tables). Make sure you place the foreign keys in the right tables.
7. Using Access, create tables with proper records for the entities. You will have to come up with some realistic records so that you can complete the next step.
8. Establish possible relationships among the tables using the foreign keys (Enforce Referential Integrity)
9. Create at least four queries.
10.Create a report that shows records from two tables.
(See the attached files)
We must fill the attached Project Charter.
We need to follow the system development phases attached.