Determine the values of customer id

Assignment Help Management Information Sys

Reference no: EM133209977

Assignment:

1. Given a big relation BB and full functional dependencies in the relation, BB (CID, CNAME, CADDRESS, CPHONE, FILM ID, TAPE NUM, TITLE, RATE, CONDITION, TYPE, PRICE, DUE_DATE)

Customer Name (CNAME), Address (CADDRESS), and customer phone (CPHONE) can be determined by knowing the values of customer ID(CID)
The title, rate, and type of a film can be identified by knowing the values of film identification number (FILM_ID).
The rent price of a film (PRICE) is determined by the values of type of film (TYPE)
The condition of a film (CONDITION) can be checked by the values of film identification number (FILM_ID) and tape number (TAPE_NUM).
The due date (DUE_DATE) of a film by a customer can be determined by the value of customer ID (CID), film identification number (FILM_ID) and tape number (TAPE_NUM).

a) Draw functional dependency diagram for BB to identify a partial and a transitive dependency.

b) Decompose BB into smaller relations that all are in 3NF. Provide relations in 2NF and 3NF respectively.

Reference no: EM133209977

Questions Cloud

Briefly summarize routine activities theory : Choose the theory with which you most agree. In 2 page, briefly summarize this theory and explain why you picked this theory over the other

Define applied anthropology : The Maasai in the "Tribal Wives" video. Define applied anthropology. Discuss why language extinction is an important issue.

What is new in critical illness and injury science : What's new in critical illness and injury science? Mental health and COVID-19: Self-inflicted and interpersonal violence amid a pandemic

Identify two mental health treatment services : Identify 2 Mental health treatment services, identify 2 Disability and accessibility services and Identify 2 Substance abuse services in Dekalb County

Determine the values of customer id : Customer Name (CNAME), Address (CADDRESS), and customer phone (CPHONE) can be determined by knowing the values of customer ID(CID).

What is a habeas post-conviction petition : What is a Habeas post-conviction petition? Does new evidence exist that may or may not support a Habeas Corpus action on behalf of John Smith

Discuss homeland defense and homeland security intelligence : Discuss Homeland Defense and Homeland Security intelligence. Of the IC members, which role does each primarily support

What is industrial alienation : What is industrial alienation? Give one example of an activity that is most likely to be associated with industrial alienation?

Advantages and disadvantages of victim compensation : What are some of the advantages and disadvantages of victim compensation in general? Why is this such a controversial topic

User Account

All Pages