Question: DATABASE Question 1: Create one database and then write SQL statements to create, in this database, all tables derived from the ERD given in the

DATABASE Question 1: Create one database and then DATABASE

Question 1: Create one database and then write SQL statements to create, in this database, all tables derived from the ERD given in the following picture with appropriate attributes, primary keys and foreign keys. 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. 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", "Alter database", "use database_name" or any statements using database's name in your submission emplD varchar(30) Name: nvarchar(50) title: nvarchar(100) JobID: int Employees Jobs N N Email: nvarchar(200) description: text WorkOn Branches branchName: nvarchar(50) address: nvarchar(100) Picture

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!