Answered step by step
Verified Expert Solution
Question
1 Approved Answer
can you help me Task 2: Normalize the following table to 3NF. State any assumptions you make about the data shown in the table. [04][5
can you help me
Task 2: Normalize the following table to 3NF. State any assumptions you make about the data shown in the table. [04][5 Marks) Employee Employee Department Department Project Project Name No. Name No. Name No. Abdullah D211 Hiring Campaign E1012 Fatenta 0233 Accounting P34 Salary Raise E1013 Aleena 0234 Networking 244 Upgrading Software's E1014 Hanya DIE Administration 45 Purchasing Goede Elons Salem Registration Registration System E1016 Muna D234 Networking 144 Upgrading Software's En HR P33 444 Pus Submission Date ($): Tuesday (10/May/2022) Assessment Weighting: 10 Marks WHAT TO SUBMIT You are required to submit a PDF file of your assignment through Moodle which contains all the required tasks such as: ER diagram based on task 1 . First, second and third normal forms of task 2 Assessment Criteria: Na Assessment Criteria Marks Task 1: Entity Relationship Diagram Appropriate Fintity nami Relationships Attributes Primary keys Cardinality, participations and assumptions 5 Task 2: Normalisation First normal form Second normal form Thind malform Total Mark 710 End of document Page 4 of 4 Remark: Candidates are advised to read all instructions before answering Objectives: The following student learning outcomes of the course are in this continuous assessment tool: 03. Identify the modeling symbols for the most popular ER modeling tools 04. Apply a good database design using normalization and ER modeling The assignment covers the following graduate attributes: Critical Thinking Problem Solving Description of the Tool: The assignment consists of two tasks. In first task, you are required to draw an Entity Relationship (ER) diagram from a given specification (or problem statement). In second task, normalize the data given in a table by applying first, second and third normal forms. TASK 1: Design an Entity-Relationship diagram for the ABC hospital. Indicate the relationships including cardinality and participation. Identify primary key, any assumption and resolution of many-to- many relationships. [03][5 Marks) A database will be made to store information about patients in a hospital. On arrival, each patient's personal details (name, address, and telephone number) are recorded where possible, and they are given an admission number. They are then assigned to a particular ward (Accident and Emergency, Cardiology, Oncology, etc.). In each ward there are a number of doctors and nurses. A patient will be treated by one doctor and several nurses over the course of their stay, and each doctor and nurse may be involved with several patients at any given time Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started