Part 1 . I need a relational scheme for that database Then start working on a r
. I need a relational scheme for that database
Then start working on a relational schema for your project. Do this by forward-engineering your ER diagram using the techniques discussed in class.
Map all entities and relationships correctly. There should be at least four tables, and there may be more.
Be sure to specify a primary key for every relation.
Include foreign keys as appropriate.
Give each foreign key attribute a descriptive name, especially if it is not clear from context. A good way to do this is to use the name of the relationship in the ER diagram that the FK came from, combined with the name of the primary key the FK is referring to.
Make sure all the attributes in a single relation have different names. Try to make the names descriptive, but not too long.
Use ERDPlus.com to construct the relational schema diagram. Export the diagram as a high-resolution PNG and upload it to Canvas.
Exercise data definition language