Database Management Systems:
Project description:
Purpose: The Database Management Systems Project develops your understanding of a chosen DBMS technology and essential design and implementation skills. It is essential that you become familiar with the use of analytical skills for database analysis and design and so the development is oriented towards real-world domains. The project will also enhance your ability to work in team and communicate effectively.
Project Requirements:
The Database Project involves your team of Database specialists working directly with the management of the company. Your team is required to develop a proposal that will solve the problems and challenges facing the company.
1. Conduct an analysis of the business to identify the data management and processing problems and challenges that is facing;
2. Devise a database strategy for the company. Include the following in your documentation along with an appropriate narrative.
Business rules that govern relationships between entities.
A Data Dictionary/System Catalogue.
An Entity-Relationship Diagram (ERD) showing the fully normalized relations. You may use either Chen or Crows Foot notation.
Relational tables and diagram for the ERD created above (Using Microsoft Access). Entity and referential integrity rules need to be considered when you create tables.
Perform queries that summaries the key data in your project. Explanation and justification for each query should be included.
Refer to the Marking Criteria below for the elements, mark allocations and a brief description of each element for the Project. You must also follow the report layout and submission guidelines when preparing your report.