Determine entities from functional requirements

Assignment Help Basic Computer Science

Reference no: EM1366506

Visio Project

1. Read the description below:
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.
2. 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.
3. Determine the entities from the functional requirements.
o 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
o Open Visio, Use the Database Model Diagram Template
o Draw an Entity for each entity you identified
o In Definition add a Physical Name
4. For Each of the entities identify attributes
o Select Columns and add attribute names
5. Using the Crow's feet, determine and draw relationships between the entities. (Typically verbs in sentences will identify these)

Reference no: EM1366506

Questions Cloud

Determine methods used to record revenues and expenses : Suppose you decided that owning a coffee shop would be perfect. Rather than start from scratch, however, you & your partners decide to look at 2-existing establishments,

Responsibility of stakeholders : In what ways have the stakeholders contributed to make the present health care system in the United States too complex and unmanageable?

Write the diffent entities or objects : Write the diffent entities or objects,logical processes,data flows, and dfata stores which are involoved. starting from time you submitted your time sheet.

Dividend based problems : Stock X has a required return of 12%, a dividend yield of 5%, and its dividend will incease at a constant rate forever. Stock Y has a required return of 10%, a dividend yield of 3%,

Determine entities from functional requirements : Using Crow's feet, determine and draw relationships between entities. (Typically verbs in sentences will recognize these). Find out the entities from functional requirements.

Tracking and evaluating training effectiveness : Describe the process for tracking and evaluating training effectiveness.

Determine the net present value of a project : Determine the net present value of a project that need a net investment of $76,000 and create net cash flows of $22,000 every year for seven years?

Castulon corporation drug-testing program : Specific policy for the program that includes disciplinary procedures for dealing with employees who test positive for drug use.

Demographic changes and cultural values : How have demographic changes and cultural values influenced the evolution of health care delivery systems in the United States?

User Account

All Pages