Solutions for the class exercises chap6

Solutions for the class exercises chap6 - , name,...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Solutions for the class exercises Solutions for conversion problem 1 on pg 210 1. The conversion rules used for this problem Entity Type Rule: generate home, owner, agent, and office tables 1-M Relationship Rule: foreign keys in home (agentid and ssn) and agent (officeid) 2. DDL pk underlined, fk in red home(homeid , agentid , ssn , street, city, state, zip, nobedrms, nobath, sqft, price, commission, ownoccupied) FOREIGN KEY(agentid) REFERENCES agent FOREIGN KEY(ssn) REFERENCES owner agent(agentid , officeid , name, phone) FOREIGN KEY(officeid) REFERENCES office owner(ssn
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: , name, spousename, profess, spouseprofess) office(officeid , mgrname, phone, address) Solutions for conversion problem 2 on pg 210 1. The conversion rules used for this problem • Entity Type Rule: generate statement and stmtline tables • 1-M Relationship Rule: foreign key in stmtline • Id Dependency Rule: make the combination of stmtno and lineno the primary key 2. DDL pk underlined, fk in red • statement(stmtno , date, acctno) • stmtline( stmtno , lineno , mername, transdate) • FOREIGN KEY(stmtno) REFERENCES statement...
View Full Document

This note was uploaded on 12/22/2009 for the course DBST DBST 651 taught by Professor Yelena - ta during the Spring '09 term at MD University College.

Ask a homework question - tutors are online