University |
|
Subject | 5COSC020W DATABASE SYSTEMS COURSEWORK |
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.
QUESTION 2: ENTITIES (08 Marks)
a) Identify and list the main entities for Vacoliday.
b) Create an Entity Data Dictionary Table to document the identified entities.
To produce this supporting documentation, fill in the table below to briefly explain each entity.
Facing challenges with your 5COSC020W DATABASE SYSTEMS COURSEWORK in the UK? Our service offers UK students specialized to navigate through the intricacies of your project. Dive into the Vacoliday Project Brief and master the building blocks of the Conceptual EERD without stress.
Pay our experts for invaluable assistance, allowing you to focus on comprehending the subject deeply. Let us guide you through this coursework, ensuring your academic success effortlessly. Trust our expertise and excel in your studies!