CS 333- Homework (ER-to-Relational Conversion)
Note: Submitted work must be typed
Convert the following ER diagram into a rudimentary relational schema1. The diagram
describes part of the business of a real state company that has several branches. The dia
Jacob Carlson, Dan Cook, Michael Eldred,
The proposed application will assist in managing a small collectible card retailer. The
retailer sells all manner of collectible cards fro
Steps in the ER-to-Relational Mapping
1. Create a relation for each strong entity type.
2. Create a relation for each weak entity type.
3. For each binary 1:1 relationship choose an entity and
CS 333 (A) - Concepts of Database Systems
Homework on Normalization
Convert the following relations into BCNF
JOB (clientId, jobNo, firstName, lastName, address, phone, referredBy,
jobdescription, estTime, estCost, plannedStartDate, plannedEndDate, ac