Hi, not very familiar with mysql. I have here a mysql statement:
table customer:
CREATE TABLE Customer
(SID integer,
Last_Name varchar(30),
First_Name varchar(30),
PRIMARY KEY (SID));
table orders:
CREATE TABLE ORDERS
(Order_ID integer,
Order_Date date,
Customer_SID integer,
Amount double,
Primary Key (Order_ID),
Foreign Key (Customer_SID) references CUSTOMER(SID));
My question is, how are you going to identify if the referencing is a one-to-many or a one-to-one relationship??