NOTE that when creating the SQL commands as request, you MUST keep the name of tables, relationship, attributes and data type of attributes as SAME as given in the given ERD.
Attributes with underline belong to the Primary Key of each entity.
Using identity(1,1) for auto increment
Generated table from the multi-valued attribute, using a combination of the entity's name and multi-valued attribute's name(for example: Employees Hobby)
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 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.
EmployeeID:auto increment (identity)
FirstName:varchar(50)
Salary:money
n
LastName:varchar(50)
Employees
n
Manage
Has
1
Departments
1
DepartmentID:auto increment (identity)
DepartmentName:varchar(100)
Gender:
Bit
Address:
Hobby:
Zoom
Control
FUO
+ 100%
Close
