Attributes which reference to the primary key of another table must have the same name as the attributes in the primary key of the referencing table.
When submitting the responses onses for this question, submit only SQL statements for creating tables with corresponding keys and foreign keys. Do not use "create database", "Alterdatabase", "use database_name" or any statements using database's name in your submission.
DeptID:varchar(20)
name:nvarchar(200)
EmpCode:varchar(20)
N
Name:nvarchar(50)
Departments 1
Belongs To
Employees
office:nvarchar(100)
BirthDate:date
has
N
Dependants
Number: int
Name:
nvarchar(50)
BirthDate: Date
Role:nvarchar(30)
Question 3.
Zoom
Picture 1.1
+ 100%
Close
