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

icon
Related questions
Question
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
Transcribed Image Text: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
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer