RELATIONAL SCHEMA

RELATIONAL SCHEMA - Split words with _ , and keep up a...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Split words with _ , and keep up a similar layout for naming the attributes. 1. Person(Person_id , Last_Name, First_Name, MI, Address, Phone_Number, Email_Address) a. Employee(Person_id 1 , SSN, Salary, Birth_Date, Date_of_Hire) i. SalesRepresentative(PersonEmployee_id 1a , SSN 1a ) ii. CustomerServiceRepresentative(PersonEmployee_id 1a , SSN 1a ) b. Customer(Person_id 1 , Territory_id 9 , AdvertisementMedium_id 7 , PersonSalesRep_id 1ai , Referred_by_PersonEmployee_id 1a , Referral_Customer_id 1b ) i. PayingCustomer(Person_id 1 ) ii. LeadCustomer(Person_id 1a ) 2. WorksIn(PersonEmployee_id 1a , Department_id 5 ) 3. Order(PersonEmployee_id 1a , Order_id , Project_id 4 , Time_Stamp, Amount, Payment_Method, Supplier_id 2027 , Shipper_id 2128 , Product_id 2229 )
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Project(Project_id , Commisions_Cutsomter_id 1b Responsible_Employee_id 1a This should be an n:n relationship. Subgroup for contractor was already made in DEPARTMENT (added by us) 4. , Completion_time_stamp)) 5. Department(Department_id
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/07/2010 for the course IND ENG 115 taught by Professor Staff during the Fall '08 term at Berkeley.

Page1 / 3

RELATIONAL SCHEMA - Split words with _ , and keep up a...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online