Zoom
tables, relationship, attributes and data type of attributes as SAME as given in the given
Attributes with underline are 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.
If a table must be created for representing a relationship, the name of the table must be the same as the name of the relationship.
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.
You must use ER style conversions for subclasses in this diagram.
ownerID: int
vehicleID:int
maker:varchar(30)
name:nvarchar(50)
Owner
Vehicle
has
Question 2:
bodyStyle:varchar(30)
NumDoors:
int
IsA
Car
Picture 1.1
model:varchar(30)
year: int
type:varchar(30)
Motorcycle
engineSize:int
Display all male members who were born after the year 1990 as follows:
MemberID MemberName
Address
Email
[email protected]
Sex BirthDate
1
9
David Wilson
13
Daniel Thomas
666 Spruce St, Everywhere, USA
111 Maple St, Nowhere, USA
[email protected] Benjamin Garcia 777 Birch St, Everywhere, USA
Male 1995-07-03
Male 1991-04-18
19
[email protected]
Male 1996-08-18
4
25
Mason Perez 101 Elm St, Everywhere, USA
[email protected] [email protected]
Male 1996-04-05
5 31
Liam Garcia
777 Cedar St, Anytown, USA
Male 1994-03-18
6 37
Jack Taylor 101 Cedar St, Somewhere, USA
[email protected]
Male 1992-07-31
Picture 2.1
Question 3:
+ 100%
Close
