vvnen submitting the responses for this question, submit only SQL statements for creating les 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)
Major:
nvarchar(50)
departmentID:
varchar(20)
Student
ISA
Person
IsA
LastName:
varchar(30)
salary:money
Employee
startDate:date
M
has
1
Department
name:nvarchar(50)
Picture 1.1
Question 2:
Display all male members who were born after the year 1990 as follows:
4 of 4
Paper No: 6
3
MemberID MemberName
9
David Wilson
13
19
25
Mason Perez
Address
Email
666 Spruce St, Everywhere, USA
[email protected]
Sex BirthDate Male 1995-07-03
Male 1991-04-18
Daniel Thomas 111 Maple St, Nowhere, USA
[email protected]
Benjamin Garcia 777 Birch St, Everywhere, USA
[email protected]
Male 1996-08-18
101 Flm St. Everywhere LISA
mason
[email protected]
Male 1996.04.05
+ 100%
Close
