Write a clear summary for a company’s senior management team, their stakeholders, and shareholders: Organisational summative report Assignment Singapore, Singapore

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.

Task 2 Implementation 
a) Create all of the normalised tables from task 1b) in SQL. Write your SQL scripts clearly showing the commands you have used with the keys, data types and field lengths. Show the finished tables and ensure they are consistent with the tables you created earlier.
b) Enter a range of sample data in all tables (minimum THREE (3) rows per table).
c) Write FIVE (5) queries that demonstrate your knowledge and understanding of SQL. SQL statements to be used should include all of the following: Select, Update, Delete, From, Where, And, Count, Ascending, Order By. Ensure TWO (2) of your queries use multiple commands.
TWO (2) of the queries should join TWO (2) or more tables together.

Task 3 (LO 3) 
Provide a written assessment and evaluation of the work you have undertaken.
Your discussion should include:
1) How the database you have created meets the data and information
requirements of your chosen organisation as identified in task 1a).
2) Why the use of ER modelling is an essential part in the design of a database
solution, and how you used it to identify and rectify any design issues you
encountered.
3) Any assumptions that you have made.
4) How the database supports the transactions that you identified in task 1a).