Skillage I.T - DB Project Scenario - Data Analysis Assignment

Data Analysis Assignment:

You are a Database Technician for a consulting company named ‘Skillage I.T.’. You have been tasked with building a new database for a client. You will use your newly gained knowledge to plan and create the database project in order to facilitate a successful outcome for Skillage I.T. and the client. The client has been accessing the information via a flat.csv file, reading the information, processing it and then closing it down. It has been decided they would like to keep the information in a database so it can be accessed without the need to re-import the file each time. The client has decided to allow Skillage I.T. to design the data table in whatever structure and using whichever database we deem suitable. 1. Choose which database you will use to hold the data, 2. Create the table(s) required in the database ensuring the correct schema is applied. 3. Import the data from the .csv file into the database. 4. Produce a collection of documents and diagrams that outline the database design. The deliverables include: a. An Entity Relationship or Object diagram b. Data Structure i. Primary and Foreign keys ii. Indexes iii. Data dictionary (metadata) iv. Normalisation profile