Design a normalized (3NF) database representing one or more of the following datasets. Each table must...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Design a normalized (3NF) database representing one or more of the following datasets. Each table must have multiple fields and no repeating groups, with each field dependent upon the entire primary key. This is a logical design only (do not use a DBMS). The physical design will be added in a future lesson. Use the following syntax to document your completed design. Use PascalCase for table and field names. Table names should be plural. Tablel (PrimaryKey, Field2, Field3, ...) Table2 (PrimaryKey, Field2, Field3, ...) 1. A car dealership wants a database to track sales by customer, vehicle, and sales person. 2. A college wants a database to track enrollment by student, course, and instructor. 3. A company wants a database to track their organizational structure by department, employee, and location. 4. A computer repair company wants a database to track repairs by customer, computer, and technician. 5. A doctor's office wants a database to track patient visits by doctor, patient, and visit. 6. A library wants a database to track books by title, author, and genre. 7. A YouTube subscriber wants a database to track videos by subject, YouTuber, and playlist. 8. Choose your own dataset similar to the above with at least three related entities. Design a normalized (3NF) database representing one or more of the following datasets. Each table must have multiple fields and no repeating groups, with each field dependent upon the entire primary key. This is a logical design only (do not use a DBMS). The physical design will be added in a future lesson. Use the following syntax to document your completed design. Use PascalCase for table and field names. Table names should be plural. Tablel (PrimaryKey, Field2, Field3, ...) Table2 (PrimaryKey, Field2, Field3, ...) 1. A car dealership wants a database to track sales by customer, vehicle, and sales person. 2. A college wants a database to track enrollment by student, course, and instructor. 3. A company wants a database to track their organizational structure by department, employee, and location. 4. A computer repair company wants a database to track repairs by customer, computer, and technician. 5. A doctor's office wants a database to track patient visits by doctor, patient, and visit. 6. A library wants a database to track books by title, author, and genre. 7. A YouTube subscriber wants a database to track videos by subject, YouTuber, and playlist. 8. Choose your own dataset similar to the above with at least three related entities.
Expert Answer:
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date:
Students also viewed these databases questions
-
What is distinctive about robo-advisors? Portfolios are created by an algorithm Provide a full array of financial planning services, including tax and estate Provide dedicated in-person advisor...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
We will be working with a company called Global Bike Inc., (GBI). Information regarding GBI follows. Company History Global Bike Inc. has a pragmatic design philosophy that comes from its deep roots...
-
What are the "two main lines" of distortion of the view of Marx and what does Lenin think the proper view?
-
Exercises 21, formulate the null and alternative hypotheses for a hypothesis test. State clearly the two possible conclusions that address the given claim. A high school teacher claims that the...
-
For the following exercises, find the decomposition of the partial fraction for the nonrepeating linear factors. 5x + 16/x 2 + 10x + 24
-
1. Define contingent net present value (NPV). Outline and explain the differences between standard and contingent NPV.
-
On December 15, MSC Corporation acquires its first foreign affiliate by acquiring 100 percent of the net assets of the Armaselah Oil Company based in Saudi Arabia for 930,000,000 Saudi Arabian...
-
Question 6.3 Describe three ways to analyse ToyoMaster's financial performance (reported in the income statement). If you need additional information beyond that presented in the income statement in...
-
1. What is the cost of direct materials used? 2. What is the cost of indirect materials used? 3. What is the cost of direct labour? 4. What is the cost of indirect labour? 5. What is the cost of...
-
Question #4 has part A, B, and C. Need help with them all! Question 4 of 6 \( -/ 9 \stackrel{i}{3} \equiv \quad \) : Difference between Implied and Book Value Advances to Kimberly Company Advances to...
-
Gilbert Canned Produce (GCP) packs and sells three varieties of canned produce: green beans; sweet peas; and tomatoes. The company is currently operating at 82 percent of capacity. Worried about the...
-
Apply at least two of the theories (of your choice) to your personal experience? The theories are Leader-Member Exchange Theory (LMX Model), the Situational Leadership Model, the Contingency Model...
-
Game theory is used in economics, social science and computer science to understand and predict the behaviour of people and intelligent entities. In project management and business scenarios, it can...
-
During a chemistry lab, you take a 0.2 kg sample of ice and put it in a beaker with a thermometer. You then place the beaker with the ice on a hot plate, and turn on the hot plate. This hot plate...
-
Selected information from Carla Vista Ltd.'s statement of financial position and statement of income is as follows: Carla Vista Ltd. Statement of Financial Position (partial) December 31 2024 2023...
-
Exercise 10-8A Record cash dividends (L010-5) On March 15, American Eagle declares a quarterly cash dividend of $0.050 per share payable on April 13 to all stockholders of record on March 30...
-
Discuss the concept of the looking-glass self. how do you think others perceive you? do you think most people perceive you correctly?
-
Why is local control of data an advantage in a distributed database?
-
What are permissions? Explain the relationship between permissions and work groups.
-
For the following exercises, you will answer problems and questions from management at TAL Distributors. You do not use the TAL Distributors database for any of these exercises. 1. Fragment the...
-
53. A city starts a public library that has separate incorporation and gets some of its money from the state and some from private donations. Indicate whether each of the following independent state...
-
RESEARCH CASE 1 The City ofAbernethy has three large bridges built in the later part of the 1980s that were not capitalized at the time. The citys accountant is interested in receiving suggestions as...
-
51. Use the same information as in problem 50 except that, by the end ofYear 3, the landfill is 40 per cent filled. The city realizes that the total closure costs will be $3 million. Indicate whether...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App