Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. How many rows does this table have? How many columns are there in each row? 2. You have been asked by your manager to

image text in transcribed

1. How many rows does this table have? How many columns are there in each row?

2. You have been asked by your manager to print a report for todays staff meeting that shows all the managers sorted by last name and then first name. In looking at the way the attributes in the table were created, what will make it problematic to create such a report? What changes would make it much easier to build such a report?

3. In looking at the data in the table, do you see the potential for data anomalies to occur? If so, describe one such area in the table.

image text in transcribed

4. Examine the attributes (columns) in the table above. Do you see more than one entity described? If so, how many different entities do you see and what are they?

5.A table that holds attributes for more than one entity is susceptible to anomalies. Do you see any susceptibilities in the table above? If so, give an example.

6. When a table contains attributes for more than one entity, a separate table should be created for each entity (not for each entity instance) and the attributes for that entity should belong to it. Given the example above, how many tables should you build? What should their names be? What attributes should they contain?

image text in transcribed

7. table above stores teacher class schedules at a local college. Find an example of a data anomaly in the table. What do anomalies tell you about the design of a table?

8.Based on your answer to the previous question, what should be done to eliminate these anomalies? How many tables would you create, what would you name them, and which attributes would go into which tables?

9. Why is it so important to make sure a database is well-designed before creating it?

10. Do a Google search using the terms bad database design health care and summarize your findings on the impact of bad database design on the health care industry. Your summary neednt exceed a paragraph.

Use the table in the figure below to answer questions 1 to 3. PROJECT CODE PROJECT MANAGER MANAGER PHONE MANAGER ADDRESS 21-5Z 25-2D 25-5A 25-9T 27-40 29-2D 31-7P Holly B. Parker Jane D. Grant George F. Dorts Holly B. Parker George F. Dorts Holly B. Parker William K. Moor 904-338-3416 615-898-9909 615-227-1245 904-338-3416 615-227-1245 904-338-3416 904-445-2719 3334 Lee Rd., Gainesville, FL 37123 218 Clark Blvd., Nashville, TN 36362 124 River Dr., Franklin, TN 29185 3334 Lee Rd., Gainesville, FL 37123 124 River Dr., Franklin, TN 29185 3334 Lee Rd., Gainesville, FL 37123 216 Morton Rd., Stetson, FL 30155 PROJECT_BID_PRICE 16833460 12500000 32512420 21563234 0314545 25559999 56850000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Seven NoSQL Databases In A Week Get Up And Running With The Fundamentals And Functionalities Of Seven Of The Most Popular NoSQL Databases

Authors: Aaron Ploetz ,Devram Kandhare ,Sudarshan Kadambi ,Xun Wu

1st Edition

1787288862, 978-1787288867

More Books

Students also viewed these Databases questions

Question

Explain how the caloric values of foods are determined.

Answered: 1 week ago

Question

Discuss the need to split data into test and training data.

Answered: 1 week ago