This preview shows page 1. Sign up to view the full content.
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.
- Spring '09
- Yelena - TA