Question
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
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.
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?
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started