EECS 3421 Midterm: EECS-3421A test1-f2016

• School: York University
• Department: Electrical Engineering and Computer Science
• Course: EECS 3421
• Professor: All

Document Summary

There is no negative penalty for a wrong answer: for schema, the underlined attributes indicate a table"s primary key (and are, hence, not nullable). The nova scotia forestry works (nsfw) oversees logging1 of trees in the province. They have commissioned you to do an e/r design for a database to help them track logging. There are two types of entities that register with the nsfw: logging companies that intend to log in nova scotia; and owners who own forested plots of land that are zoned for logging. For a company to log, or for an owner to sell logging rights on a plot or his or hers, each needs to be licensed by the nsfw. A licensee is assigned a unique licence# by the nsfw, has an issued date, and has an address (either the company"s address or the owner"s address, depending). For an owner, we are to keep additionally the owner"s name.