Describe the six properties of relations

Assignment Help Management Information Sys

Reference no: EM133131703

Assignment Details:

Question 1. Describe the six properties of relations? What makes a relation differ from an entity?

Question 2. Be sure to explain how you determined the normal form you selected.

For each of the following relations, indicate the normal form for that relation. If the relation is not in third normal form, decompose it into 3NF relations. Functional dependencies (other than those implied by the primary key) are shown where appropriate.

a. CLASS(CourseNo, Section No)

b. CLASS(CourseNo, Section No, Room)

c. CLASS(CourseNo, SectionNo, Room, Capacity) [FD} Room Capacity'
CLASS(CourseNo, SectionNo CourseName, Room, Capacity)
[FD: CourseNo -> CourseName; F13: Room -> Capacity]

Question 3. You can use any tool you'd like for parts a-d (pen and paper is acceptable!). MySQL will be needed to create the ERD requested in part e.

1380_relational schema.png

Table 4-4 shows a relation called GRADE REPORT for a university. Your assignment is as follows:
a. Draw a relational schema and diagram the functional dependencies in the relation.
b. In what normal form is this relation?
c Decompose GRADE REPORT into a set of 3NF rela-tions.
d. Draw a relational schema for your 3NF relations and show the referential integrity constraints.
e. Draw your answer to pan d using Microsoft Visio (or any other tool specified by your in.structor).

Question 4. The Public Safety office at Millennium College maintains a list of parking tickets issued to vehides parked illegally on the campus. Table 4-6 shows a portion of this list for the fall semester. (Attribute names are abbreviated to conserve space.)

2009_relational schema1.png

a. Convert this table to a relation in first normal form b entering appropriate data in the table. What are the determinants in this relation?
b. Draw a dependency diagram that shows all functional dependencies in the relation, based on the sample data shown.
c. Give an example of one or more anomalies that can result in using this relation.
d. Develop a set of relations in third normal form. Include a new column with the heading Violation in the appro¬priate table to explain the reason for each ticket. Val¬ues in this column are: expired parking meter (ticket code 1), no parking permit (ticket code 2), and handi¬cap violation (ticket code 3).
e. Develop an E-R diagram with the appropriate cardinal-ity notations.

Reference no: EM133131703

Questions Cloud

Explain why spam senders frequently change : Explain why spam senders frequently change from one email address and one domain to another.

Accountable For Misuse Of Their ATM Cards : What do you think of the European practice of holding consumers more accountable for the losses incurred from skimming if ATM cards?

Nutrition deficit is link to criminal behavior : Some developmental theorists contend that nutrition deficit is a link to criminal behavior. Do you agree or disagree?

Criminal justice arena : Select a real-life example within the Criminal Justice arena, where the organization's structure (i.e., both formal and informal,

Describe the six properties of relations : Describe the six properties of relations? What makes a relation differ from an entity and explain how you determined the normal form you selected

Differentiate between management and leadership : Differentiate between management and leadership. Explain the difference between centralized and decentralized organizations.

Obtain a 30-year home mortgage : You obtain a 30-year home mortgage and your monthly payment is $3000.00. Instead of paying monthly as required, you ask the bank to allow you to pay $36,000 at

Determine the total overhead flexible budget variance : Under a two-variance analysis (breakdown) of the total overhead variance for the period, determine the total overhead flexible budget (FB) variance

Consistent with cluster personalities : Identify and explain features in the primary offender that are consistent with Cluster A personalities.

User Account

All Pages