"University XYZ needs a database that keeps track of students, what classes they taken and the grades for each of the classes. In addition, they need to know what instructors are on staff and the courses they are approved to teach. It is necessary to track rooms for each campus including capacities as well as special facilities for each room.

Another tool used to infer the conceptual model are the end user's forms. The form below will help you identify the entities and relationships.

form Lab 1

# Determine the entities from the functional requirements.

* Entities can come from Nouns in the text, they may also come from forms, reports and legacy code
You must identify at least 4 entities
* Open Visio, Use the Database Model Diagram Template
* Draw an Entity for each entity you identified
* In Definition add a Physical Name

# For Each of the entities identify attributes

* Select Columns and add attribute names

# Using the Crow's feet, determine and draw relationships between the entities. (Typically verbs in sentences will identify these)" "