Computers and Technology, 20.02.2020 04:23 iyanistacks50
Video centers of europe, ltd., is a chain of movie DVD rental stores. it must maintain data on the dvds if has for rent, the movies recorded on the DVDs, its customers, and the actual rental. each dvd for rent has a unique serial number. movie titles and customer numbers are also unique identifiers. assume that each movie has exactly one "star." note the difference in the year that the movie was originally filmed and the date that a dvd an actual disk was manufactured. some of the attributes and functional dependencies in this environment are as follows:
attributes:
dvd numbers, manufacture date, movie title, star, year filmed, length (min), customer numbers, customer name, customer address, rent date, return date, fee paid
functional dependencies:
dvd number>>>>movie title
dvd number>>>>star
dvd number>>>>manufacture date
movie title>>>>star
movie title>>>>length
movie title>>>>year filmed
customer number>>>>customer name
customer number>>>>customer address
dvd number, customer number
rental date>>>>return date, fee paid
for each of the following tables, first write the table's current normal form (as 1nf,2nf,3nf). then, take those tables that are currently in 1nf or 2nf and reconstruct them as well structured 3nf tables. primary key attributes are in bold. do not assume any functional dependencies other than those shown.
a)movie title, star, length, year filmed
b)dvd number, customer number, rental date, customer name, return date, fee paid
c)dvd number, manufacture fate, movie title, star
d)movie title, customer number, star, length, customer name, customer address
e)dvd number, customer number, rental date, return date, fee paid
Answers: 3
Computers and Technology, 22.06.2019 18:30
Kto rozmawia z clamentain przez krótkofalówke w the walking dead która śledzi lee w 4 epizodzie
Answers: 1
Computers and Technology, 22.06.2019 20:30
In this lab, you complete a prewritten c program that calculates an employee’s productivity bonus and prints the employee’s name and bonus. bonuses are calculated based on an employee’s productivity score as shown below. a productivity score is calculated by first dividing an employee’s transactions dollar value by the number of transactions and then dividing the result by the number of shifts worked.
Answers: 3
Computers and Technology, 23.06.2019 10:50
Your friend kayla is starting her own business and asks you whether she should set it up as a p2p network or as a client-server network. list three questions you might ask to kayla decide which network to use and how her answers to those questions would affect your recommendation.
Answers: 2
Computers and Technology, 24.06.2019 18:20
7. design a circuit with three inputs (x, y, and z) representing the bits in a binary number, and three outputs (a, b, and c) also representing bits in a binary number. when the input is 1, 2, or 3, the binary output should be one lesser than the input. when the input is 4, 5, or 6, the binary output should be one greater than the input. when the input is 0, the output is 0, and when the input is 7, the output is 7. show your truth table, all computations for simplification, and the final circuit.
Answers: 2
Video centers of europe, ltd., is a chain of movie DVD rental stores. it must maintain data on the d...
History, 23.09.2021 01:00
Mathematics, 23.09.2021 01:00
History, 23.09.2021 01:00
Chemistry, 23.09.2021 01:00
Mathematics, 23.09.2021 01:00
Mathematics, 23.09.2021 01:00
Computers and Technology, 23.09.2021 01:00
English, 23.09.2021 01:00
Arts, 23.09.2021 01:00
Mathematics, 23.09.2021 01:00
Mathematics, 23.09.2021 01:00