1. Problem 1
a. ER Diagram
b. Relational schema:
Customer (cid, cname, caddr, cccn, cemail)
App (aname, ades, did)
did is referenced to did in Developer relation
Developer (did, dname, demail)
Device (dtype, dos, cid, deid)
cid is referenced to cid in Cus
At first I build a simple html form, and provide an input area to input keyword.
And then I use post method of PHP to implement. After input this keyword, it will
show the table names belongs to this database. And then if I click the table name,
(a) Yes, it is necessary to have all of seller, iid, and starttime in the primary key for Auction.
If we only use iid as primary key in auction, it means that items of the same type must be sold in
auctions by the same user and start to sell in
A container that holds objects
If you have the files for an existing SQL Server database, the easiest way to create the database is
to _ those files to the database sever.
main data file, log file
The two types of files in a SQL Server datab