vvnen 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.
You must use ER style conversions for subclasses in this diagram.
personID:int
FirstName:varchar(30)
Person
LastName:varchar(30)
Major:nvarchar(50)
IsA
IsA
salary:money
Employee
M
Student
startDate:date
departmentID:
varchar(20)
Department
1
name:nvarchar(50)
Picture 1.1
Zoom
Question 2:
Display all female authors whose country is 'United Kingdom' as follows:
has
+ 100%
Close
