COMP1350 - Introduction to Database Design and Management - Computer Science Assignment Help

Assignment Task

Task 1- EER Diagram (60 marks) Based on the business rules, you are expected to construct an Enhanced-ER (EER) diagram. The EER diagram should include entities, attributes, and identifiers. You are also expected to show the relationships among entities using cardinality and constraints. You may choose to add attributes on the relationships (if there are any) or create an associative entity, when necessary. Your diagram should also specify the complete (total) and disjoint (mutually exclusive) constraints on the generalization/specialization.

Task 2- Logical Transformation (40 marks) Based on your EER, perform a logical transformation. Please use 8a for your step8 to keep the process simple. Please note, if there are errors in the EER diagram, this will impact your marks in the transformation. However, the correctness of the process will be taken into account. What to include in your report (as a PDF)

• To present your answers to these tasks, please use the template provided in the assignment folder.

• Fill out the details provided on the first page of the template.

• For Task 1, attach the image in the document of the EER model you have created. You can use a tool of your choice to generate the diagram. Hand-drawn diagrams will not be accepted.

• For Task 2, write the answers under the right space in the template. Steps have to be clear with primary and foreign keys listed explicitly.

• Assumptions: If you have any assumptions, please list them down in the first page of the report. (e.g. about relationships between entities in your EER Model). Please note only make assumptions if something is not clear. Assumptions will only be valid if they are not contradicting something which is given in the case study.

• If your images lack clarity, you will not be given any marks. Tutors can zoom in to check the diagram but should not have to deal with images that are blurry / fuzzy. Whatever is submitted is the final submission. So, please make sure your image is readable.

This (COMP1350) Computer Science Assignment has been solved by our Computer Science 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 distinctio.