Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Data Management Systems

22/09/2020 Client: joediv12 Deadline: 7 Days

Database Project #1 for a Museum Database: Conceptual Data Design using E-R.


The OldCity museum, which owns several millions paintings, has asked you to do the conceptual design of a database for the following information requirements.


Data about each painting include a unique name (PK), year completed,  year acquired, estimated value, a “school” (e.g. Impressionism).  Each painting was created by one or several painters, although the painters of some paintings are unknown.  Due to shortage of display rooms, the least valuable paintings are kept for long period of times in storage rooms, whereas the most valuable ones are shown in display rooms.   A room is identified by a unique room number and a size (in  square  feet).


Some of the OldCity museum paintings may be on loan to associate museums, typically for several months, with a specified return date.   Each associate museum has one curator, with whom the OldCity museum negotiates loaned paintings.  


Customers of the OldCity museum consist of members and non-members.  Members may have one or several specialties (for example impressionism or Cubism).      Members may be regular members or VIP members (members having reached some donation level).   A regular member may serve as a docent at  certain dates and times in specific rooms to explain the room paintings to visitors.  The OldCity museum organizes gala nights.   A gala night honors one living painter  (on a given date, there may be several gala nights for different painters; a painter may not have more than one gala night on a given date).  Only invited VIP members can attend a gala night.  On a few specific dates and times,  “Special Days”  are organized to entice non-members to become members  Non-members need to register to be invited to such Special Days.


Data for painters: Painter_Id (PK), Name, date of birth, date of death, country of birth


Data for all Customers: CustID (PK), name, birthdate, gender


Data for curators: CurID (PK), name, birthdate


Data for “associate  museums” : unique museum name (PK),  city, country


Deliverables:


A  (8/10) An Entity-Relationship Diagram (ERD)


B. (2/10)  preceded with answers to the following questions.  You may want to review your answers as you work on the ERD.


1.  Is Customer at the top of a generalization hierarchy.   Justify your choice.


2.  Is Painting at the top of a generalization hierarchy.  Justify your choice.


3. “although the painters of some paintings are unknown”.  What do you do about this information?  Justify


4.  How do you show the information about “gala nights”?  Justify.


5. “A regular member may serve as a docent at  certain dates and times in specific rooms to explain the room paintings to visitors.”    What do you do about this information?  Justify


Presentation Guidelines


Try to draw the ERD using an appropriate software.  If you draw by hand, please use a ruler. If you scan, make sure the resulting drawing has the correct orientation. No credit otherwise. 


Use only the “Crow’s foot” conventions, as in Koster.


A few reminders about ERDs.  


1. Underline the primary keys (solid line).  Each entity type must have a PK, except “children” of generalization hierarchies, weak entity types, and associative entities.


2. Each relationship must show a unique name.


3. Do not use ternary relationships


4. If your ERD has generalization hierarchies, they must be oriented as in Koster.


5.  Completeness is more important than simplicity.  Do not simplify, if this results in the loss of information.


6. Do not show foreign keys

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Top Academic Guru
Academic Master
Assignment Hub
Ideas & Innovations
Exam Attempter
Writer Writer Name Offer Chat
Top Academic Guru

ONLINE

Top Academic Guru

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$15 Chat With Writer
Academic Master

ONLINE

Academic Master

I have super grip on essays, case studies, reports and discussion posts. I am working on this forum from last 6 years with full amount of satisfaction of my clients.

$20 Chat With Writer
Assignment Hub

ONLINE

Assignment Hub

I feel, I am the best option for you to fulfill this project with 100% perfection. I am working in this industry since 2014 and I have served more than 1200 clients with a full amount of satisfaction.

$35 Chat With Writer
Ideas & Innovations

ONLINE

Ideas & Innovations

Hi, Hope you are doing well. I can do this easily because I have several experiences to write articles on different web sites, creative content for several blogs & also SEO writing. Even I have written many kindle ebooks, Being a creative writer, I think I am the most eligible person for your Ghostwriting project. So lets make no longer delay & start chatting immediately.

$40 Chat With Writer
Exam Attempter

ONLINE

Exam Attempter

I will help you with your online exams, quizzes and assignment with A+ grades. Please give me a chance and get relax :)

$20 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Discounted cash flow dcf analysis generally - Top efficiency %%+27835179056 %%% SAFE abortion pills for sale NAMIBIA Botswana kwazulu_natal WITBANK SECUNDA PONGOLA - Week 11 Discussion - English 2 Page work - Cement bond log test - Toshiba internal control failure - Nh4oh hcl balanced equation - Chasers war on everything mcdonalds - 25/8 as a mixed number - Impact of team building exercises on team effectiveness - Sociology - Dependability and reliability describe two aspects of the _____ factor of the five-factor model. - Help 1 - Characteristics of a care worker - Synthesis Paper: Doctoral Identity - Valley pool table disassembly - Biological approach to abnormality - Poetry analysis example pdf - Mike's bikes simulation best strategy - St michaels hospital enfield - Reliance r12 security system - How long is an extended response - University of bonn plant sciences - Reaction time experiment ruler conclusion - Break even sales under present and proposed conditions - Range rule of thumb in statistics - Comic strip about Rosa Parks or Neil Armstrong - Book Response - 1.1 atm to kpa - Timothy hackworth primary school - Carrefour sa case solution - The extraordinary leader zenger folkman pdf - Human communication degree ucf - What is the electron configuration for w - B1 topic form example - Discussion 7a - Exploratory essay topics about sports - Digging up the past - Watashi wa nihongo ga wakarimasen - Arb canopy load rating - Nursing - Par level calculation - June 2013 physics paper - Journal 8 - Conclusion paragraph for the great gatsby - Bill of materials in construction - Genograms are based upon the premise that - A 1550 kg car moving south at - Student support unit sussex - Az animals com white tiger - Discussion - Management science - Shake and bake gassing - Contrived contingency - Explain the phases of change noted in the Linear Development in Learning Approaches in the Information Technology and Organizational Learning text. - Three sources of artifacts in eeg recordings - Conclusion of online shopping essay - What is zara organizational structure - Lucy y lee hung pekín china - Article summarizing - Marketing Paper - Discussion 10 - Case-3 - What Are The Components Of Genuine ESA Letter - Master on EE and my work - Norwegian school of economics - Cyclone tracy evacuees list - You manage the intranet servers for eastsim corporation - Policy Identification and Analysis - Regiocentric approach advantages and disadvantages - Principles of Industrial and Organizational Psychology - View the film "Phil Zimbard - Kongsberg simulator mc90 free download - How to measure transient voltage - Writing a memo - Getting coffee is hard to do analysis - Pent ca gov forms htm - Unit 1 Scholarly Activity - Please see attachment - Read the article by Popenoe (link here) - The Fog of War - Term Paper - 700words: Effective leadership - Derbyshire county council matlock blue badge - 1610 abyss drive odessa fl - Harmonization of accounting standards ppt - Dulux all metal primer - Financial management challenges and ethics - Human Resources Management - Charter club opulence 800 thread count review - Joel watson strategy instructor's manual - Timeshare exchange fair - Leadership style of google ceo - Wearable computers change how we work - Jack wills swot - Leather sector skill council - Gaussian elimination python - 3c/1 bik lane fitzroy north - Multiple input signature register tutorial - Triage assessment form for crisis intervention