Find the entities from the functional requirements

Assignment Help Database Management System

Reference no: EM1366844

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.

# 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)

Reference no: EM1366844

Questions Cloud

Electronic health record for medical errors : Explain an electronic health record and describe how it can help decrease medical errors.

Provide formula to calculate equal monthly installments : You have decided to buy a house. The home is valued at $200,000 and you seek a mortgage in the value of $150,000. If you can get a 6 percent mortgage for thirty years

Movement along demand curve and shift in demand : Describe the difference between movement along the demand curve and a shift in demand. Provide an example to help the class understand the difference between the two.

Selection and placement decisions minimizes differences : Selection and placement decisions are made effectively, performance differences among employees

Find the entities from the functional requirements : Find the entities from the functional requirements. Entities can come from Nouns in the text, they may also come from forms, reports and legacy code.

Change and diversity : Describe how changing demographics are impacting patients and providers in the delivery of health care in the U.S.

What are the guidelines for the brainstorming process : Explain what are the guidelines for the brainstorming process? Identify two problems on or off the job for which you think brainstorming would be effective.

Health care policy : Describe at least one health care policy measure designed to decrease hospitalization of nursing home residents. Are there any disadvantages or limitations of this policy?

Show how changing a name can improve reputation : Do you see where changing the name and improving customer service allows an organization to completely change its reputation and re-group

User Account

All Pages