![subject](/tpl/images/cats/informatica.png)
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
![ansver](/tpl/images/cats/User.png)
Answers: 3
![](/tpl/images/ask_question.png)
![](/tpl/images/ask_question_mob.png)
Another question on Computers and Technology
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 06:50
Type the correct answer in the box. spell all words correctly. which view of report creation allows you to customize the report before the database program creates it? creating a report in allows you to customize the report before the database program creates it. pl asap
Answers: 1
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 17:40
Gabe wants to move text from one document to another document. he should copy the text, paste the text, and open the new document highlight the text, select the cut command, move to the new document, make sure the cursor is in the correct location, and select the paste command select the save as command, navigate to the new document, and click save highlight the text, open the new document, and press ctrl and v
Answers: 1
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 03:30
Hashtags serve to identify the topic of a given tweet true false
Answers: 2
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 07:00
Why were most movies from the late 1890s until the early 1930s only filmed in black and white? there were only a few people who could afford the technology to produce color motion pictures back then. audiences did not want color motion pictures until later. the film used to make color motion pictures often overheated, which was a safety hazard, so it was generally not allowed. color films had to be hand-colored, frame by frame.
Answers: 3
You know the right answer?
Video centers of europe, ltd., is a chain of movie DVD rental stores. it must maintain data on the d...
Questions
![question](/tpl/images/cats/istoriya.png)
History, 27.09.2020 22:01
![question](/tpl/images/cats/mkx.png)
Arts, 27.09.2020 22:01
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
Mathematics, 27.09.2020 22:01
![question](/tpl/images/cats/fizika.png)
![question](/tpl/images/cats/himiya.png)
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/mat.png)
Mathematics, 27.09.2020 22:01
![question](/tpl/images/cats/mat.png)
Mathematics, 27.09.2020 22:01
![question](/tpl/images/cats/mat.png)
Mathematics, 27.09.2020 22:01
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
Mathematics, 27.09.2020 22:01
![question](/tpl/images/cats/mat.png)
Mathematics, 27.09.2020 22:01
![question](/tpl/images/cats/biologiya.png)
Biology, 27.09.2020 22:01
![question](/tpl/images/cats/mat.png)
Mathematics, 27.09.2020 22:01
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/fizika.png)
Physics, 27.09.2020 22:01
![question](/tpl/images/cats/User.png)