COM4003: Database Design - Understanding of Databases and Data Management System - IT Assignment Help

Assignment Task:

Assignment Brief 

As part of the formal assessment for the programme you are required to submit a Database  Design assessment. Please refer to your Student Handbook for full details of the programme  assessment scheme and general information on preparing and submitting assignments. 

Learning Outcomes: 

After completing the module, you should be able to: 

1. Demonstrate a knowledge and understanding of databases and data management  systems. 

2. Understand key principles of relational database design techniques. 

3. Transform a logical database design into a physical database design for a target  database management system. 

4. Apply knowledge and understanding of database design and development to  design, implement, test, document and evaluate a relational database solution for  a given scenario. 

5. Use appropriate problem-solving techniques. 

Your assignment should include: a title page containing your student number, the module  name, the submission deadline and a word count; the appendices if relevant; and a reference  list in Arden University (AU) Harvard format. You should address all the elements of the  assignment task listed below. Please note that tutors will use the assessment criteria set out  below in assessing your work. 

Question 1 (Covers LO 1) 

(a) Summarize the key benefits that the database approach to data management offers  over traditional file-based data management. Answer with regards to this case study. 

(b) List and briefly describe the major features to be found in a commercial database  management system (DBMS). 

Question 2 (Covers LO 2) 

Develop a semantically rich data model that captures the above scenario in the form of an  entity-relationship diagram (ERD). You should note (and number) all assumptions you make  about the data and the reasoning behind your design choices. Also, include (and number) any  appropriate constraints and a list of entity types showing their attributes and identifiers. 

Question 3 (Covers LO 2) 

Once you are satisfied that the ER diagram is a good representation of the organisation’s data  requirements, produce a logical design by mapping the ER diagram to a set of normalized  relations – to third normal form (3NF). You should annotate and explain this process. 

Question 4 (Covers LO 3) 

Take each of the normalized relations and implement them as SQL tables using an appropriate  DBMS – such as Oracle, MySQL or another one you have access to – and a series of CREATE  TABLE statements. You must include all primary and foreign keys as well as any other table  or column constraints you feel are appropriate such as NOT NULL, CHECK, UNIQUE and  DEFAULT. Provide screenshots of the working code. Ensure your user name or some other  distinguishing aspect is included in the screenshot to verify it is your code. 

Question 5 (Covers LO 4) 

Using appropriate sample data and your own imagination based on this case study, populate  your finished tables with at least 10 rows of data in each table. Provide screenshots of the  working code. When done, display the full contents of each populated table to screen and take  screenshots. Ensure your user name or some other distinguishing aspect is included in the  screenshot to verify it is your code.

This COM4003: IT Assignment 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.