Midterm Part 2 CSCI 1320(3) -Word References Mailings Review View TNormal 1 No S
ID: 3734521 • Letter: M
Question
Midterm Part 2 CSCI 1320(3) -Word References Mailings Review View TNormal 1 No Spa.. Heading 1 Heading2 Title Sublitl Styles Paragraph Part 2-Written Analysis CSCI 1320 Database Fundamentals You have been assigned to a new development team. A client is requesting a relational database system to manage their present store with the anticipation of adding more stores in the future You received an email from the client with the list shown below. Currently, this list tracks their daily business. To prepare for the meeting with the client, you develop a first draft design In your one page MS Word document include the following 1. Table(s) needed 2.Eields for each table (list primary key field first) 2 Name at least 7 additional fields. > Which field or fields shown below do not belong in a table? Explain why e ldentify the primary key for each table by underlining Name the relationships by identifying the fields which are foreign keys to other fields Develop 3 questions to ask client at your face-to-face meeting next week that will assist in refining the design. Price Robert 12/14/2012 Antique Desk 1 249 3249Explanation / Answer
1.There are four tables which can be made
a)Customer
b)Items
c)Invoice
d)Seller
2.
a)Customer:cid,cname,caddress,cmobileno,cmail,cpassword,ctype,cbdate.
b)Items:id,sid(foreign key),name,quantity_available,category,price,tax,special_offer,.
c)Invoice:invoice_id,item_id(foreign key),seller_id(foreign key),date.
d)Seller:sid,sname,saddress,sphoneNo,sEmail,item_id(foreign key),sPassword.
>>Fields like names,address, username and password of the customer and seller,category of item, are additional fields.
>>The total field doesn't belong to any table because it is a derived attribute and can be calculated and directly utilised.
>>The field that lies first in the above list is the primary key.
>>Realtionships:
Customer(cid) buys Items(item_id)
Seller(sid) sells Items(item_id)(sid)
Seller(sid) Generates Invoice(invoice_id)(item_id)
Questions:
1.How large is the online store system is and what are your specific requirements?
2.Do you have direct contacts with warehouses or you get your supplies by the retail sellers?
3.What are the diffrent categories of products you sell?