ISYS224- Database Design & Implementation- Information Technology Assignment help

Assignment Task

ISYS224- Database Design & Implementation- Information Technology Assignment help 

Task 1: Conceptual data model

• Add a screenshot of your conceptual data model in the form of an enhanced ER (EER) model (the model must be legible, when zoomed in). Note that you should not show the foreign keys in the EER model.
• Identify and justify the use of, if any, generalization /specialisation, weak entity types, and attributes on relationships.  
• List your assumptions (if any) over and above what was provided in the problem domain description.

Task 2: Logical data model

• Add a screenshot of your logical data model (the model must be legible, when zoomed in).
• Discuss how you translated the conceptual data model into the logical data model – briefly. 
• You may refer to specific translation / conversion rules discussed in the lectures 

Task 3: Logical data model

• List the functional dependencies (after making necessary assumptions) for each relation in the logical data model of Task 2. 
• Identify the normal form each relation is in and justify it according to the definition of the corresponding normal form (e.g., if a relation is already in 2NF and doesn’t have any transitive dependencies, it is in 3NF).  
• You may refer to the process of normalization discussed in the lectures 

Task 4: DDL

• Add your DDL scripts to implement the relevant tables in the relational data model in MySQL as per the requirements in the assignment description.
• Add snapshots of the tables populated with data (the snapshots must be legible, when zoomed in) 

Task 5: DML???????

• Add your DML scripts for the queries Q1 – Q5 as per the requirements in the assignment description.
• Note that these SQL queries must be tested using the data you inserted in Task 4.  
• Add snapshots of the results / tables of the execution of the queries Q1 – Q5 (the snapshots must be legible, when zoomed in) 

This ISYS224- Database Design & Implementation Assignment has been solved by our IT Expert 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.