Organisational summative report Assignment

153 views 8:49 am 0 Comments October 18, 2023

Task 1 Analysis and Design 
Produce the following documents:

a) Introduction, outline and initial analysis:

Write a clear summary for a company’s senior management team, their
stakeholders, and shareholders. Assume that your summary will be read by those who have very limited knowledge or digital skills in databases.

In your summary use clear language and fully explain the technical terms so that the readers can understand its contents. The summary should:

1) Introduce the company and describe what it does.
2) Explain what a database is and what typical functions the proposed database will perform.
3) Clearly list and describe the transactions the database will carry out to help daily functions of the organisation.
4) List all entities to be included in the database.
5) Identify and discuss specific advantages and disadvantages of implementing a database for the organisation.

b) Using the list of entities and functions identified in task 1a), complete the following:
1) Draw an Entity Relationship Diagram ERD and list and normalise to 3
rd normal form (3NF) all of the attributes that will be required in the database.
2) The Entity Relationship Diagram (ERD) should show at least SIX (6) data
entities from the initial analysis from the identification of the transactions that
was carried out in task 1a).
3) Provide a written statement of any problems that you encountered during the process of creating the ERD and production of 3rd Normal Form (3NF) and
explain the process you undertook to resolve them.
c) Create a full Data dictionary for the entity relationship model using the entities and attributes identified in task 1b). The data dictionary should include the following:
1) All of the attributes used.
2) Identify all primary, foreign and compound keys that you have created
3) Show the data type for each attribute used
4) Include any field constraints that have been identified from your chosen
organisation.

Tags: , , , , , , , , , ,