Fundamentals of Database Design, Implementation, Management - IT Assessment Answer

 IT Assessment Task

1: Show an understanding of the fundamentals of database design, implementation, management, and maintenance, including consideration of appropriate data security
2: Implement a relational database using the Structured Query Language (SQL) Data Definition Language (DDL)
3: Demonstrate an ability to query a relational database using Structured Query Language (SQL) and Data Manipulation Language (DML)

1. Part A: Aim
To give you practical experience in database modelling, normalization and writing SQL statements to query a relational database

Project Specification:
1. Part A: Entity Relationship Diagram

2. Your first task is to study the Case study requirements and gather as much knowledge to list all the main Entities and attributes.
3. Create an Entity Relationship Diagram (ERD) to help you decide on the relationships.
Your entity relation diagram that models your database design should:
i. Include all entities, relationships (including names) and attributes.
ii. Identify primary and foreign keys.
iii. Include cardinality/ multiplicity and show using crow’s feet or UML notation.
iv. Include participation (optional / mandatory) symbols if applicable.

2. Part B: Normalisation

•  Normalise all entities and relationships in optimal normal form. Provide the normalised schema and discuss the level of normalisation achieved for each relation. You goal should be normalise all entities in 3NF. Provide the reasons for any relation that is not maintained in 3NF.

3. Part C: Relational schema and MySQL database 

•  Create relational schema that matches ERD and normalised schemas you created in Part A and B. The schema should include suitable data validation, integrity and referential integrity constraints, for example, types and length of attributes, primary and foreign keys etc. Make sure you follow standards, naming conventions and notation.

This IT Assessment has been solved by our IT experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.