Question: Now its visible Question 1 and Question 2 are based on the following ER model, which is illustrated in standard ER notations but has been

Now its visible Question 1 and Question 2 are based on the Now its visible

Question 1 and Question 2 are based on the following ER model, which is illustrated in standard ER notations but has been drawn incorrectly andcontains many errors Question 1 The above ER diagram is incomplete and has been drawn incorrectly due to the following reasons: (a)A COMPLAINT is not related to an advertisement but related to a 4 Marks NEWS PAPER ADVERTISEMENT DEVELOPMENT APPLICATION NewsPaperld AdvertisementDate Charges (b) Each OPEN COMPLAINT is a COMPLAINT and they should be related to each other ComplaintDescription (c) ach NEWS_PAPER charges differently for the same ADVERTISEMENT (d)Relationship names are missing in the ER diagram. Complete and correct the errors in the given ER diagram and redraw it using standard ER notations onlv Question 2 Answer the following questions based on the given ER model. You need to briefly 4 Marks DEVELOPMENT APPLICATION justify your answers. (a) How many DEVELOPMENTAPPLICATIONS can be placed in any one OPEN COMPLAINT Applicationld ApplicationDate BuildingPlan PlotNum StreetAddress City PostCode ComnlaintID ADVERTISEMENT? (1 mark) ComplaintDate ComplainingPerson ComplaintDescription (b) Can an ADVERTISEMENT appear in more than one NEWS_PAPER? (1 mark) (c) As per the ER diagram, a DEVELOPMENT APPLICATION may not appear in any of the ADVERTISEMENTS. What could be the reason to model it in that wa (1 mark) (d) Which type of relationship is the most appropriate for the relationship between COMPLAINT and OPEN_COMPLAINT? Why? (1 mark)

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!

Question 1 and 2 are based on the following ER model, which is illustrated in standard ER notations. TEST TestName Charges perform APPOINTMENT Patient SPECIALISTwith Appointmentid Patientld...

Unit Learning Outcomes This assessment is relevant to the following Course Learning Outcomes: ULO a: Discuss database management systems' concepts, types, functions, and architecture. ULO b: Apply...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

A creative engineer suggests structuring the TLB so that not all the bits of the presented address need match to result in a hit. Suggest how this might be achieved, and what might be the costs and...

Welcome! Please read this page (in particular) very carefully. Instructions You need to understand how to send your assignments (deliverables) Instructor: to your instructor. The tabs (bottom of each...

From the book Networks, Crowds, and Markets: Reasoning about a Highly Connected World. By David Easley and Jon Kleinberg. Cambridge University Press, 2010. Complete preprint on-line at...

P e e r -R e v ie w e d O p tim iz in g Safety Engineering, Systems, Human Factors: Part 1 By Vladimir Ivensky T safety program is to reduce or eliminate in cidents that result in harm to people or...

I need help with the article. I need to do 2 pages summary for the article ( CEO Turnover and Audit Pricing) I attatch . I attach the summary sample of article ( On the Timing of CEO Stock Option...

Please I need help with the questions for Calculations (Part ), Calculations (Part 2), the graph, and questions 1-2 on the last page. THE DATA TO DO THE CALCULATIONS ARE PROVIDED IN THE TABLES. THATS...

Charlene owns a 70% interest in Maupin Mopeds, which is organized as a partnership. She wants to open another business and needs office space for it. She has Maupin distribute a building worth...

Williams Ltd manufactures iron gates to individual customers specifications. The company use the tender process to obtain work, where the company responds to an invitation to submit a competitive...

Referring to the information concerning the MBA decision, what is the Present Value of the income and expenses associated with attending FSU for his MBA? $ 1 , 1 2 8 , 8 5 3 . 4 2 $ 1 , 0 7 9 , 6 1 5...

8:37 * N. 80% i ... OBJECTIVES: Create relationships Create a Pivot Table from Related Tables Create a PivotChart Modify the PivotChart The major section in this chapter :ontinuation is: Data...