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

Discussion - Discuss the difficulties in measuring the intelligence of machines. - Hovey house boston college - DB1 Expert tutor - Http medievaleurope mrdonn org - The four lenses of wellness - Assignment wk3 - Analog way quickvu manual - Attendance and punctuality performance appraisal - Summary of ngarrindjeri history - Designer baby scalisi vs ny univ medical center p 429 - 5 7 driving data answers - Silicon tetrachloride can be prepared by heating - 3.1 10 practice complete your assignment - Power world simulator online - Hr discussion - Statistics homework MCs - Physiology - How do humans impact watersheds - Extraction of eugenol from cloves by steam distillation - Crossover distortion op amp - St ignatius uniform shop - A2 level english vocabulary list - Naoh and benzoic acid reaction - Urban Expansion in the New Nation - Pdf index generator free - Implement the following function with two level nor gate circuit - Tenet group iit madras - Alist definition to kill a mockingbird - Bangladesh india professional skill development institute - 15.2 linking verbs practice 2 answer key - Bsbmkg501 assessment 2 answers - Three classes of mollusks - Public relations writing strategies & structures 11th edition pdf - Glenskirlie house restaurant menu - Peri peri chicken george street parramatta - Somewhere i have never travelled poem analysis pdf - Rosemount 3051sal level transmitter - The Impact of Demographics Changes - Wedding plan gantt chart ms project - Level 1 dfd for food ordering system - Special occasion speech outline pdf - Ten commandments coptic orthodox - Telecom cable color code - Sales engineer comp plan examples - Managerial economics a problem solving approach edition answers - Multiple choice questions on is lm model - Me talk pretty one day author's goal - JOHANNESBURG SAFE ABORTION CLINIC +27835179056 PILLS IN JOHANNESBURG musina limpopo polokwane - Nommar model - Le chatelier's principle lab answers - Pfa online test answers - Tpg home phone service - Class3wk1obj1 - I fell into your brown eyes - Brad's bicycle shop sells speed bicycles - Dissertation topic - Wisconsin quarter horse association - Isaac newton interview questions - Stobhill ambulatory care hospital - Snow cam baw baw - Application to general manager - Cisco aironet 1240ag default password - Dickey john auburn il - Www psychology sunysb edu attachment online inge_origins pdf - Ymca informed consent for exercise participation - Communication Assessment Project - Fictional narrative - Mt baw baw accomodation - PR /Media sporting event - Gcu spss download - Father o'leary's velvet cream - Persuasive speech outline on blood donation - Opc 478uc cloning cable - Quiz - ME - Online - Dis 5 - Software architecture exam questions and answers - Artist resale royalty australia - Robin williams core american values - Strayer university presidents list - Sylvia plath nick and the candlestick - Hydrotherapy indications and contraindications - True or false? a larger sample size produces a longer confidence interval for μ. - Credit Score and Financial Analyst - Asic strike off action - Walmart's strategy is to grow in ____ areas - Ccpc mortgage overpayment calculator - Equality and more - An element crystallizes in a body centered cubic lattice - Types of soft engineering - Papa johns swot analysis 2017 - Unisuper member account number - Chemistry a level syllabus - Principles of Management - The centerpiece of the marketing environment analysis framework is - Freedom furniture stockholm nest of tables - As/nzs 3500 free download - University of rochester chemistry department - Molar mass and evaporation rate - Coles job resume sample