Question: Fill in the gaps in the Relational Database Schema for two (2) relations that represent the two (2) corresponding entities shown in the Entity Relationship Diagram (ERD) below. Figure: Entity Relationship Diagram (ERD) Employee Department Employee number Dept number First name works Last name in Dept name Dept location Job title Dept number Instructions: In the table below write your answers in one word only. Spell your answer correctly. Table: Relational Database Schema for the given ERD Relation name Column name DeptNumber Data type INTAI Description type your answer.... key Department DeptName type your answer... (60) Example 'School of ICT DeptLocation VARCHAR(5) EmployeeNumber INTAI FirstName VARCHAR(40) Example -'N44" Primary key Examples - Mohammad' Employee LastName VARCHAR(40) Example - 'Awrangjeb Job Title VARCHAR(60) Example - 'Senior Lecturer' DeptNumber type your answer... type your answer... Department.DeptNumber key-References
Question: Fill in the gaps in the Relational Database Schema for two (2) relations that represent the two (2) corresponding entities shown in the Entity Relationship Diagram (ERD) below. Figure: Entity Relationship Diagram (ERD) Employee Department Employee number Dept number First name works Last name in Dept name Dept location Job title Dept number Instructions: In the table below write your answers in one word only. Spell your answer correctly. Table: Relational Database Schema for the given ERD Relation name Column name DeptNumber Data type INTAI Description type your answer.... key Department DeptName type your answer... (60) Example 'School of ICT DeptLocation VARCHAR(5) EmployeeNumber INTAI FirstName VARCHAR(40) Example -'N44" Primary key Examples - Mohammad' Employee LastName VARCHAR(40) Example - 'Awrangjeb Job Title VARCHAR(60) Example - 'Senior Lecturer' DeptNumber type your answer... type your answer... Department.DeptNumber key-References
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps