PART 2 A. Entity Relationship Diagram (using crows foot notation) B. Document Relationships between entities using...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
PART 2 A. Entity Relationship Diagram (using crows foot notation) B. Document Relationships between entities using format below Relationship Parent Child Type Cardinality Maximum Cardinality Minimum Cardinality (1:1, 1:N or N:M) | (O-M, 0-0, M-M or M-O) C. Document Actions to enforce minimum cardinality using format below Actions for required parent in [Table 1] - [Table 2] [Table 1] is required parent of [Table 2] Action on [Table 1] Action on [Table 2] Actions Insert Modify key or Foreign key Delete D. Create a Data Dictionary based on ERD and Normalization solution. Provide SQL server data types for each of the columns in every table you have identified. Identify the primary and foreign keys in each table: Name of the Entity Attributes Null/Not Null or other SQL Server Data Type PK/FK/AltK constraints Patient Number 1736 First སྐ Harriet Maness Address 2 嚣 9368 Bucklin MO 64631 4177716403 237763124 6/16/1954 F 10/7/2020 Braces $3,500.00 Impression Felicia 150000 Hillcrest Street Material Hunter 1736 Harriet Maness 1736 Harriet Maness 1736 Harriet Maness 2649 Jess Fraga 9368 Hillcrest Street 9368 Hillcrest Street 9368 Hillcrest Street 30 Polygon St. Bucklin MO 64631 4177716403 237763124 6/16/1954 F 10/7/2020 Braces $3,500.00 Impression Felicia Trays Hunter 150000 Bucklin MO 64631 4177716403 237763124 6/16/1954 F 8/25/2022 Cleaning $200.00 Fluoride Felicia Hunter 150000 Bucklin MO 64631 4177716403 237763124 6/16/1954 F 8/25/2022 Cleaning $200.00 Cleaners Felicia Hunter 150000 Oronogo MO 64855 8168921621 448299828 10/11/2003 9/15/2021 Cleaning $200.00 Fluoride Felicia 150000 Hunter 2649 Jess Fraga 30 Oronogo MO 64855 8168921621 Polygon St. 448299828 10/11/2003 F 9/15/2021 Cleaning $200.00 Cleaners Felicia 150000 Hunter 2649 Jess Fraga 30 Oronogo MO 64855 8168921621 448299828 10/11/2003 F 3/9/2021 Polygon St. Restoration with local anesthesia $210.00 Numbing Agent Felicia 150000 Hunter 2649 Jess Fraga 30 Polygon St. Oronogo MO 64855 8168921621 448299828 10/11/2003 F 3/9/2021 Restoration with local anesthesia $210.00 Amalgam Felicia Hunter 150000 2657 Arcelia Ibarra 35 Smoky Scotts City MO 65756 8168322641 546754766 12/6/1991 F 7/23/2020 Braces $3,500.00 Impression Keith Material Reynolds 160000 Hollow Dr. 2657 Arcelia Ibarra 35 Scotts MO 65756 8168322641 546754766 12/6/1991 F 7/23/2020 Braces Smoky City $3,500.00 Impression Keith Trays Reynolds 160000 Hollow Dr. Gender Visit Date Procedure or Service Done Charge Materials** Dentist Name Dentist Salary $ 2657 Arcelia Ibarra 35 Smoky Scotts City MO 65756 8168322641 546754766 12/6/1991 F 1/31/2019 Cleaning $200.00 Fluoride Keith Reynolds 160000 Hollow Dr. 2657 Arcelia Ibarra 35 Scotts MO 65756 8168322641 546754766 12/6/1991 F 1/31/2019 Cleaning $200.00 Cleaners Smoky Hollow City Keith Reynolds 160000 Dr. 2657 Arcelia Ibarra 35 Smoky Scotts City MO 65756 8168322641 546754766 12/6/1991 F 9/9/2018 Crowns and Caps $1,200.00 Crowns Keith 160000 and Caps Reynolds Hollow Dr. 2657 Arcelia Ibarra 35 Smoky Scotts City MO 65756 8168322641 546754766 12/6/1991 F 9/9/2018 Crowns and Caps $1,200.00 Numbing Keith Agent Reynolds 160000 Hollow Dr. 2834 Kelli Holiman 128 Golden Star Ave. Saginaw MO 64864 3142802397 390395751 5/4/1979 3/1/2020 Cleaning $200.00 Fluoride Rita Jensen 155000 2834 Kelli Holiman 128 Golden Star Ave. Saginaw MO 64864 3142802397 390395751 5/4/1979 F 3/1/2020 Cleaning $200.00 Cleaners Rita Jensen 155000 2834 Kelli Holiman 128 Golden Saginaw MO 64864 3142802397 390395751 5/4/1979 F 5/22/2021 Cleaning $200.00 Fluoride Rita Jensen 155000 Star Ave. 2834 Kelli Holiman 128 Golden Star Ave. Saginaw MO 64864 3142802397 390395751 5/4/1979 F 5/22/2021 Cleaning $200.00 Cleaners Rita Jensen 155000 2834 Kelli Holiman 128 Golden Star Ave. Saginaw MO 64864 3142802397 390395751 5/4/1979 F 11/24/2019 Dentures $950.00 Impression Material Rita Jensen 155000 2834 Kelli Holiman 2834 Kelli Holiman 128 Golden Star Ave. 128 Golden Star Ave. Saginaw MO 64864 3142802397 390395751 5/4/1979 F 11/24/2019 Dentures $950.00 Impression Trays Rita Jensen 155000 Saginaw MO 64864 3142802397 390395751 5/4/1979 F 6/10/2022 Restoration $185.00 Amalgam Rita Jensen 155000 3271 lona Piatt 8991 Galvin St. lonia MO 65335 8169433490 271523900 8/24/2004 F 5/18/2016 Cleaning $200.00 Fluoride Bethany 175000 Tucker 3271 lona Piatt 8991 lonia MO 65335 8169433490 271523900 8/24/2004 5/18/2016 Cleaning $200.00 Galvin Cleaners Bethany 175000 Tucker St. 3271 lona Piatt 8991 lonia MO 65335 8169433490 271523900 8/24/2004 F 7/18/2018 Galvin Crowns and $1,200.00 Caps Crowns and Caps Bethany 175000 Tucker St. 3271 lona Piatt 8991 lonia MO 65335 8169433490 271523900 8/24/2004 F 7/18/2018 Galvin Crowns and Caps $1,200.00 Numbing Bethany 175000 Agent Tucker St. 3271 lona Piatt 8991 lonia MO 65335 8169433490 271523900 8/24/2004 F 10/13/2019 Extraction Galvin St. $263.00 Numbing Bethany 175000 Agent Tucker 3271 lona Piatt 8991 lonia MO 65335 8169433490 271523900 8/24/2004 F 7/22/2020 Galvin St. Restoration with local anesthesia $210.00 Numbing Bethany 175000 Agent Tucker 3271 lona Piatt 8991 lonia MO 65335 8169433490 271523900 8/24/2004 F 7/22/2020 Galvin St. Restoration with local anesthesia $210.00 Amalgam Bethany 175000 Tucker 3682 Bert Llewellyn 3682 Bert Llewellyn 3682 Bert Llewellyn 3682 Bert Llewellyn 3682 Bert Llewellyn 3695 Loni Asmussen 3695 Loni Asmussen 18 Autumn Street 18 Autumn Street 18 Autumn Street 18 Autumn Street 18 Autumn Street 6 Swanson St. 6 Swanson St. Bernie MO 63822 5735989702 229412809 12/28/1993 M 2/9/2018 Cleaning $200.00 Fluoride Bethany 175000 Tucker Bernie MO 63822 5735989702 229412809 12/28/1993 M 2/9/2018 Cleaning $200.00 Cleaners Bethany 175000 Tucker Bernie MO 63822 5735989702 229412809 12/28/1993 M 11/27/2019 Dentures $950.00 Impression Bethany 175000 Material Tucker Bernie MO 63822 5735989702 229412809 12/28/1993 M 11/27/2019 Dentures $950.00 Impression Bethany 175000 Trays Tucker Bernie MO 63822 5735989702 229412809 12/28/1993 M 8/29/2021 Restoration $185.00 Amalgam Bethany 175000 Tucker Eminence MO 65466 8168322641 807762312 12/6/1991 F 4/27/2021 Restoration with local anesthesia $210.00 Numbing Felicia Agent Hunter 165000 Eminence MO 65466 8168322641 807762312 12/6/1991 F 4/27/2021 Restoration with local anesthesia $210.00 Amalgam Felicia Hunter 165000 PART 2 A. Entity Relationship Diagram (using crows foot notation) B. Document Relationships between entities using format below Relationship Parent Child Type Cardinality Maximum Cardinality Minimum Cardinality (1:1, 1:N or N:M) | (O-M, 0-0, M-M or M-O) C. Document Actions to enforce minimum cardinality using format below Actions for required parent in [Table 1] - [Table 2] [Table 1] is required parent of [Table 2] Action on [Table 1] Action on [Table 2] Actions Insert Modify key or Foreign key Delete D. Create a Data Dictionary based on ERD and Normalization solution. Provide SQL server data types for each of the columns in every table you have identified. Identify the primary and foreign keys in each table: Name of the Entity Attributes Null/Not Null or other SQL Server Data Type PK/FK/AltK constraints Patient Number 1736 First སྐ Harriet Maness Address 2 嚣 9368 Bucklin MO 64631 4177716403 237763124 6/16/1954 F 10/7/2020 Braces $3,500.00 Impression Felicia 150000 Hillcrest Street Material Hunter 1736 Harriet Maness 1736 Harriet Maness 1736 Harriet Maness 2649 Jess Fraga 9368 Hillcrest Street 9368 Hillcrest Street 9368 Hillcrest Street 30 Polygon St. Bucklin MO 64631 4177716403 237763124 6/16/1954 F 10/7/2020 Braces $3,500.00 Impression Felicia Trays Hunter 150000 Bucklin MO 64631 4177716403 237763124 6/16/1954 F 8/25/2022 Cleaning $200.00 Fluoride Felicia Hunter 150000 Bucklin MO 64631 4177716403 237763124 6/16/1954 F 8/25/2022 Cleaning $200.00 Cleaners Felicia Hunter 150000 Oronogo MO 64855 8168921621 448299828 10/11/2003 9/15/2021 Cleaning $200.00 Fluoride Felicia 150000 Hunter 2649 Jess Fraga 30 Oronogo MO 64855 8168921621 Polygon St. 448299828 10/11/2003 F 9/15/2021 Cleaning $200.00 Cleaners Felicia 150000 Hunter 2649 Jess Fraga 30 Oronogo MO 64855 8168921621 448299828 10/11/2003 F 3/9/2021 Polygon St. Restoration with local anesthesia $210.00 Numbing Agent Felicia 150000 Hunter 2649 Jess Fraga 30 Polygon St. Oronogo MO 64855 8168921621 448299828 10/11/2003 F 3/9/2021 Restoration with local anesthesia $210.00 Amalgam Felicia Hunter 150000 2657 Arcelia Ibarra 35 Smoky Scotts City MO 65756 8168322641 546754766 12/6/1991 F 7/23/2020 Braces $3,500.00 Impression Keith Material Reynolds 160000 Hollow Dr. 2657 Arcelia Ibarra 35 Scotts MO 65756 8168322641 546754766 12/6/1991 F 7/23/2020 Braces Smoky City $3,500.00 Impression Keith Trays Reynolds 160000 Hollow Dr. Gender Visit Date Procedure or Service Done Charge Materials** Dentist Name Dentist Salary $ 2657 Arcelia Ibarra 35 Smoky Scotts City MO 65756 8168322641 546754766 12/6/1991 F 1/31/2019 Cleaning $200.00 Fluoride Keith Reynolds 160000 Hollow Dr. 2657 Arcelia Ibarra 35 Scotts MO 65756 8168322641 546754766 12/6/1991 F 1/31/2019 Cleaning $200.00 Cleaners Smoky Hollow City Keith Reynolds 160000 Dr. 2657 Arcelia Ibarra 35 Smoky Scotts City MO 65756 8168322641 546754766 12/6/1991 F 9/9/2018 Crowns and Caps $1,200.00 Crowns Keith 160000 and Caps Reynolds Hollow Dr. 2657 Arcelia Ibarra 35 Smoky Scotts City MO 65756 8168322641 546754766 12/6/1991 F 9/9/2018 Crowns and Caps $1,200.00 Numbing Keith Agent Reynolds 160000 Hollow Dr. 2834 Kelli Holiman 128 Golden Star Ave. Saginaw MO 64864 3142802397 390395751 5/4/1979 3/1/2020 Cleaning $200.00 Fluoride Rita Jensen 155000 2834 Kelli Holiman 128 Golden Star Ave. Saginaw MO 64864 3142802397 390395751 5/4/1979 F 3/1/2020 Cleaning $200.00 Cleaners Rita Jensen 155000 2834 Kelli Holiman 128 Golden Saginaw MO 64864 3142802397 390395751 5/4/1979 F 5/22/2021 Cleaning $200.00 Fluoride Rita Jensen 155000 Star Ave. 2834 Kelli Holiman 128 Golden Star Ave. Saginaw MO 64864 3142802397 390395751 5/4/1979 F 5/22/2021 Cleaning $200.00 Cleaners Rita Jensen 155000 2834 Kelli Holiman 128 Golden Star Ave. Saginaw MO 64864 3142802397 390395751 5/4/1979 F 11/24/2019 Dentures $950.00 Impression Material Rita Jensen 155000 2834 Kelli Holiman 2834 Kelli Holiman 128 Golden Star Ave. 128 Golden Star Ave. Saginaw MO 64864 3142802397 390395751 5/4/1979 F 11/24/2019 Dentures $950.00 Impression Trays Rita Jensen 155000 Saginaw MO 64864 3142802397 390395751 5/4/1979 F 6/10/2022 Restoration $185.00 Amalgam Rita Jensen 155000 3271 lona Piatt 8991 Galvin St. lonia MO 65335 8169433490 271523900 8/24/2004 F 5/18/2016 Cleaning $200.00 Fluoride Bethany 175000 Tucker 3271 lona Piatt 8991 lonia MO 65335 8169433490 271523900 8/24/2004 5/18/2016 Cleaning $200.00 Galvin Cleaners Bethany 175000 Tucker St. 3271 lona Piatt 8991 lonia MO 65335 8169433490 271523900 8/24/2004 F 7/18/2018 Galvin Crowns and $1,200.00 Caps Crowns and Caps Bethany 175000 Tucker St. 3271 lona Piatt 8991 lonia MO 65335 8169433490 271523900 8/24/2004 F 7/18/2018 Galvin Crowns and Caps $1,200.00 Numbing Bethany 175000 Agent Tucker St. 3271 lona Piatt 8991 lonia MO 65335 8169433490 271523900 8/24/2004 F 10/13/2019 Extraction Galvin St. $263.00 Numbing Bethany 175000 Agent Tucker 3271 lona Piatt 8991 lonia MO 65335 8169433490 271523900 8/24/2004 F 7/22/2020 Galvin St. Restoration with local anesthesia $210.00 Numbing Bethany 175000 Agent Tucker 3271 lona Piatt 8991 lonia MO 65335 8169433490 271523900 8/24/2004 F 7/22/2020 Galvin St. Restoration with local anesthesia $210.00 Amalgam Bethany 175000 Tucker 3682 Bert Llewellyn 3682 Bert Llewellyn 3682 Bert Llewellyn 3682 Bert Llewellyn 3682 Bert Llewellyn 3695 Loni Asmussen 3695 Loni Asmussen 18 Autumn Street 18 Autumn Street 18 Autumn Street 18 Autumn Street 18 Autumn Street 6 Swanson St. 6 Swanson St. Bernie MO 63822 5735989702 229412809 12/28/1993 M 2/9/2018 Cleaning $200.00 Fluoride Bethany 175000 Tucker Bernie MO 63822 5735989702 229412809 12/28/1993 M 2/9/2018 Cleaning $200.00 Cleaners Bethany 175000 Tucker Bernie MO 63822 5735989702 229412809 12/28/1993 M 11/27/2019 Dentures $950.00 Impression Bethany 175000 Material Tucker Bernie MO 63822 5735989702 229412809 12/28/1993 M 11/27/2019 Dentures $950.00 Impression Bethany 175000 Trays Tucker Bernie MO 63822 5735989702 229412809 12/28/1993 M 8/29/2021 Restoration $185.00 Amalgam Bethany 175000 Tucker Eminence MO 65466 8168322641 807762312 12/6/1991 F 4/27/2021 Restoration with local anesthesia $210.00 Numbing Felicia Agent Hunter 165000 Eminence MO 65466 8168322641 807762312 12/6/1991 F 4/27/2021 Restoration with local anesthesia $210.00 Amalgam Felicia Hunter 165000
Expert Answer:
Answer rating: 100% (QA)
First using the data that has been provided lets design the Entity Relationship Diagram ERD Lets now record the connections between the entities Conne... View the full answer
Related Book For
Database Processing Fundamentals, Design, and Implementation
ISBN: 978-0133876703
14th edition
Authors: David M. Kroenke, David J. Auer
Posted Date:
Students also viewed these programming questions
-
The following accounts and corresponding balances were drawn from Jogger Company's Year 2 and Year 1 year-end balance sheets. Account Title Accounts receivable Prepaid rent Utilities payable Other...
-
To demonstrate the ability to propose, implement, and query the database. Problem: MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and Arizona....
-
Lord of Chips seeks your advice in measuring its overall cost of capital. The firm is in the 30% tax bracket. You have collected the following information. Sources of Capital Market price New issue...
-
Coca-Cola is seeking: To determine the effect of age on intention to purchase Coke Zero; To examine the effect of price on intention to purchase Coke Zero. What are the independent variable(s) and...
-
Assume that an average firm in the office supply business has a 6 percent after-tax profit margin, a 40 percent debt/assets ratio, a total assets turnover of 2 times, and a dividend payout ratio of...
-
Find the values of the missing items (a) through(q). Purchasing Marketing Actual Results, Production Administrative Price Budget Volume Master Sales Flexible SBudget, and and 800 750 Units Variances...
-
Harley Corporation issued \(\$ 75,000\) of \(6 \%, 10\)-year, nonconvertible bonds with detachable stock purchase warrants. Each \(\$ 1,000\) bond carried 20 detachable warrants, each of which was...
-
Virginias Ron McPherson Electronics Corporation retains a service crew to repair machine breakdowns that occur on average = 3 per 8- hour workday (approximately Poisson in nature). The crew can...
-
A Bank has financial assets of $745 and liabilities of $603.45. If the duration of assets is 2 years and the duration of all liabilities is 0.91 years, what is the leverage-adjusted duration gap? ...
-
Given the bill of materials for the printer cartridge (A) shown below, a gross requirement to build 200 units of A, on-hand inventory levels for each item as shown in the table below, and assuming...
-
Parsons Corporation acquires all of the assets and liabilities of Sonata Company at the beginning of 2017, in an acquisition reported as a merger. Developed technology, not reported on Sonata's...
-
Sheffield Corporation had net income of $1940000 and paid dividends to common stockholders of $313000 in 2021. The weighted average number of shares outstanding in 2021 was 242500 shares. Sheffield...
-
(20 points) A company can produce and sell five products for the next quarter. The following table shows the variable cost of producing each unit of a product, the sales price of each unit of a...
-
a) Draw the individual modes (circuits) of operation as discussed in class. In each (circuit) mode, show clearly which device is conducting and which one isn't. Using clearly marked arrows, show the...
-
What are some of the factors that influence elasticity of demand? Define peak season and off-season for hospitality, in terms of their effect on price. What is the impact of price elasticity on...
-
Monitoring and measuring the success of our marketing programs is extremely important. Selecting measures (metrics) that are meaningful and relatively easy to monitor is very important. Let's assume...
-
TulumCo. issued a 15-year bond, with a coupon of 4.5%, making semi-annual payments and a par value of $1,000.The bond currently sells for 110% of par.The company's tax rate is 21%. 1. Calculate the...
-
A seasonal index may be less than one, equal to one, or greater than one. Explain what each of these values would mean.
-
Are there any significant differences between the CUSTOMER_01 and SALE_01 tables? If so, what are they?
-
Give examples of 1:1, 1:N, and N:M recursive relationships (other than those presented in this chapter).
-
Create and test a view called EmployeeDepartmentDataView that contains the employee name concatenated and formatted as LastName, FirstName in a field named EmployeeName, EMPLOYEE.Department,...
-
14. ROLE REVERSAL Write a multiple-choice question about defamation in which one and only one element is missing from the plaintiff's case. Choose a set of answers that forces the student to isolate...
-
Take a look at http://response.restoration.noaa.gov/. What are some of the long-term problems associated with oil spills? View some of the photos in the "gallery." Are punitive damages for oil spills...
-
Question: Explain the difference between embezzlement and money laundering. Give an example of each. Strategy: Both crimes involve money illegally obtained, but they are very different. As to...
Study smarter with the SolutionInn App