tables with corresponding keys and foreign keys. Do not use "create database", "Alter
☑ Kizspy.me database", "use database_name" or any statements using database's name in your
submission.
Zoom
CustID:
int
City:
Varchar(100)
Customers
Cname:
Varchar(100)
Odate:
OrderID:
int
date
n
Orders
hasOrder
ItemID:
int
n
Order Item
Unit Price:
decimal(10)
Items
Picture 1.1
m
Qty:
int
Question 2:
[1 mark] Write a query to retrieve the birth date and address of the employee(s) whose name
is 'John B. Smith' as follows:
+ 100%
Close
