5COSC020W DATABASE SYSTEMS COURSEWORK

141 views 8:13 am 0 Comments November 17, 2023

Part A Questions
You have been hired by Vacoliday as a Database Architect to undertake a database project to support the data needs of the company. Your job in this first part is to investigate the Vacoliday company, produce a high-quality CONCEPTUAL ENHANCED ENTITY RELATIONSHIP DIAGRAM (EERD) to support its data needs, and document it with a data dictionary. Prefix the names of all entities and attributes with your student id number starting with w (see end of doc).

QUESTION 1:INVESTIGATION, BUSINESS QUESTIONS & REFLECTIVE COMMENTARY (10 Marks)

a) Study the Vacoliday Project Brief very carefully and start identifying the building blocks of the Conceptual EERD: entities, specialisations, relationships, multiplicities, attributes, and primary keys.

b) Formulate five Business Questions (BQs) for the Vacoliday’s Board of Directors to investigate the company and clarify your understanding of the building blocks of the Conceptual EERD. Your questions must be formulated in a way that is understandable to Managing Directors who do not have technical knowledge in the field of database systems. Your questions must be unique and formulated by you only. Questions directed at lecturers will not be accepted.

c) Post your five Business Questions on the Coursework Q&A Forum on Blackboard by Friday 27 October 2023 at 17:00:00. The forum is available at:
https://learning.westminster.ac.uk/ultra/courses/_94126_1/outline/discussion _4709172_1?view=discussions&courseId=_94126_1

d) Insert screenshots of your five Business Questions and the related answers in your report, clearly identifying your full name.

e) Write a five bullet points-based Reflective Commentary to explain how each of your Business Questions helped you clarify your understanding of the building blocks of the Conceptual EERD.

Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,