Question: ID 1 2 3 4 NULL Format 35MM Digital 3D IMAX 35MM NULL 3 4 4. Using the table above for formats, what data redundancies

ID 1 2 3 4 NULL Format 35MM Digital 3D IMAX 35MM NULL 3 4 4. Using the table above for formats, what data redundancies do you detect (1pt)? 2 ID ActorName MovieID Film Character 1 1 Gal Gadot 1 Wonder Woman 2 2 Tom Holland 9 Spideman 3 3 Tom Holland 7 Spideman 4 4 Vin Diesel 5 Dominic Toretto 5 5 Scarlett Johansson 7 Natasha Romanoff 6 6 Tom Hardy 9 Venom 7 7 Hiroyuki Sanada 6 Scorpion 8 8 Ludi Lin 6 Liu Kang 9 9 Daniel Nelson 6 Kabal 10 10 Sisi Stringer 6 Mileena 11 11 Josh Lawson 6 Kano 5. Using the table above for actors, where do you see data redundancies, explain why it would be a problem (3pt)? 6. Using the actors table, what changes would you recommend for the ActorName field (2pt)? 1 2 WN 3 125 4 4 un 5 6 ID ActorName MovielD Film Character 1 Gal Gadot 1 Wonder Woman 2. Tom Holland 9 Spiderman 3 Tom Holland 7 Spiderman 4 Vin Diesel 5 Dominic Toretto 5 Scarlett Johansson 7 Natasha Romanoff 6 Tom Hardy 9 Venom 7 Hiroyuki Sanada 6 Scorpion 8 Ludi Lin 6 Liu Kang 9 Daniel Nelson 6 Kabal 10 Sisi Stringer 6 Mileena 11 Josh Lawson 6 Kano 6 ID Movie Name Release Date Rating RunTime_Minutes 1 Wonder Woman 1984 2020-12-25 3 151 2 Tom and Jerry 2021-02-26 1 96 3 Ghostbusters: Afterlife 2021-03-05 3 Morbius 2021-03-19 3 137 5 F9 2021-04-02 3 128 6 Mortal Kombat 2021-04-16 4 100 7 Black Widow 2021-05-07 3 129 8 Godzilla Vs Kong 2021-05-21 4 144 9 Venom: Let There Be Camage 2021-06-25 4 147 10 Tenet 2020-09-03 3 11 The Croods: A New Age 2020-11-25 2 95 7 8 9 10 11 150 23 7. What problems would you encounter if you deleted the Mortal Kombat movie (2pt)? 8. What is the most used language to access databases (1pt)? 9. What is metadata (2pt)? 10. Why is database design important (3pt)? 11. A question to the database is known as a what (1 pt)? 12. A spur of the moment question to the database is known as what (1pt)? 13. What is something you interact with daily that is likely using a database? Explain why you believe a database is being used. 14. What are some basic database functions that a spreadsheet (such as an Excel document) cannot perform

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Financial Statement Analysis Obtain a copy of the 2009 annual report for a publicly held firm. Try to obtain an annual report for a retail or manufacturing firm. Be sure that the financial statement...

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

Hey! Could you please assist me with this solution. I am attaching the question as well as the rubric. Please let me know if you are available to assist. Thank you in advance. \fNote: This is an...

The best definition for nonparametric statistics I can think of is when data does not fit inside the normal parameters of a normal distribution, it calls for the use of this statistical method....

Exercise 5: (15 Pts) ASCII stands for American Standard Code for Information Interchange; it is a character encoding standard for information interchange in electronics communication. Each alphabet,...

DAVID DOESN'T DELEGATE Overcoming an Individual's Immunity to Change AS ANY EXPERIENCED MANAGER will tell us, being an effective delegator is crucial to using everyone's time, skills, and knowledge...

This is an excel assignment in finance course. I will attach the assignment. Thank you FIN 301 SPREADSHEET ASSIGNMENT In this assignment you will practice using several Excel functions for managing...

For this program, you will write a chunk based decryption program. Study the base code and make the following changes: Implement display_chunks(). Loop over each string in the array of message chunks...

//////////////////////////////////////////////////////////////////////////////// //INCLUDES #include #include //macros: constants #define CHUNK_LENGTH (20+1) //each chunk has twenty characters, we...

C programming help! USE THE GIVEN CODE BELOW THE IMAGE! Answer in an easy-to-read manner!! : //INCLUDES #include #include //macros: constants #define CHUNK_LENGTH (20+1) //each chunk has twenty...

RocketOwl, Inc. is considering a new product to bring to market. They estimate the product would have a viable market for five years. If they wish to do the project they will need to purchase...

Caribbean Corporation began operations on April 1 by issuing 60,000 shares of $5 par value common stock for cash at $13 per share. Journalize the issuance.

Question 4 1 2 pts Market retum 0 . 1 3 6 Riskfree rate 0 . 0 1 6 Enter the missing values. Round to three decimat places. Choose the answer closest to yours. \ table [ [ Average DPO ? a , 0 . 6 8 3...

Q.6 Mr. and Mrs. Berry are equal partners in a family partnership. Mr. and Mrs. Berry's marginal tax rate is 35%. Next year, the partnership is expected to generate $2,600,000 of ordinary income. The...

4. How will participation impact policy decisions, problem-solving efforts, or other kinds of public (nonprofit) action? (p. 244)

2. What elements of more contemporary views of culture and change are expressed here?

how would you have done things differently?