Question

You’ve been employed by a Museum to develop the logical design of the database. If you...

You’ve been employed by a Museum to develop the logical design of the database. If you have a list of works of art and a list of museums, each work of art can only be in one museum at a time, but each museum can have many works of art. Museums have designated name, address, and an id. The works comes with a works id, description, the creator’s name. using SQL modeler

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Museums( MuseumId , MuseumName , MuseumAddress)

ArtPieces( WorksId , CreatorName , Desc , MuseumId(FK))

Names of tables are in bold.

Primary Keys have been underlined

ArtPiece Museum Key WorksID CreatorName Desc Key MuseumID MuseumName MuseumAddress ForeignKey MuseumID

Foreign Keys have been indicated.

Add a comment
Know the answer?
Add Answer to:
You’ve been employed by a Museum to develop the logical design of the database. If you...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Lab 4 – Logical Design Introduction: This lab is designed to practice database design concepts. Submission:...

    Lab 4 – Logical Design Introduction: This lab is designed to practice database design concepts. Submission: For the scenario below, draw a logical design draft on the paper, and then draw the design in the computer using PG Modeler software. After that, export the model to PNG photo. Submit to Brightspace a word file that has a photo of the draft design (on the paper) and the PNG photo that is produced from the PG modeler. Database scenario: Assume that...

  • You are a database consultant with Ace Software, Inc., and have been assigned to develop a...

    You are a database consultant with Ace Software, Inc., and have been assigned to develop a database for the Mom and Pop Johnson video store in town. Mom and Pop have been keeping their records of videos and DVDs purchased from distributors and rented to customers in stacks of invoices and piles of rental forms for years. They have finally decided to automate their record keeping with a relational database. You sit down with Mom and Pop to discuss their...

  • Project Steps: 1. Database Design 1.1. Design and create a database in third normal form based...

    Project Steps: 1. Database Design 1.1. Design and create a database in third normal form based on the following requirements: • Each Job is for a specific customer and there can be more than one job per customer. • The name and address must be tracked for each customer. • Each job is described by up to 2000 characters. • Each job has a status of ‘open, ‘in process’, or ‘complete’. • Each job has a start date and end...

  • SQL help: Design a database diagram for a database that stores information about the Downloads that...

    SQL help: Design a database diagram for a database that stores information about the Downloads that users make.  Each user must have an email address, first name, and last name.  Each user can have one or more downloads.  Each download must have a filename and download date/time.  Each product can be related to one or more downloads.  Each product must have a name. What are the PK and FK for this diagram Describe the reasoning...

  • Database design Part One (Conceptual Database Design) As a database developer, you have been asked to...

    Database design Part One (Conceptual Database Design) As a database developer, you have been asked to design a new database the operation of the new project within the Liverpool John Moores University (LJMU). LJMU i planning to deliver a number of professional training courses in Al. Each course is delivered by one member of staff at LJMU's Training Centre; each staff is allocated a staff number. The policy of LJMU is to record the start working date of each staff,...

  • You have been asked to develop a real estate database to track homes, realtors, and owners.    ...

    You have been asked to develop a real estate database to track homes, realtors, and owners.     Homes are either rented or owned and have an address, a number of bedrooms, a number of bathrooms, and square feet. An owner has a SSN, name, spouse (owner may not have one), profession, and spouse’s profession (if no spouse, then no spouse’s profession). Owners might have several homes to sell, but a home has only one owner.   Agents represent owners in the sale...

  • Your project will require you to develop a database design to solve a real-life data management...

    Your project will require you to develop a database design to solve a real-life data management problem. It can be any problem in your work environment or for another organization, for example, a bookstore (think of how Amazon uses databases), a course management system (think of how a university manages courses), a bank (think of how your bank works), and an online auction site (think of how Ebay works). You will develop a database to solve this problem You will...

  • Develop a conceptual ER diagram for the above database description, using appropriate syntaxes, and showing cardinalities...

    Develop a conceptual ER diagram for the above database description, using appropriate syntaxes, and showing cardinalities and key attributes. Consider the partial description for a UNIVERSITY database below: A university is organized into colleges, and each college has a unique name, a main office and phone, and a particular faculty member who is dean of the college. Each college administers a number of academic departments. Each department has a unique name, a unique code number, a main office and phone,...

  • this is database course please draw the ER by this way We have been asked to...

    this is database course please draw the ER by this way We have been asked to analyze the data requirements and develop a database system to keep information for equipment hiring companies in the country The aim of this system is to monitor the hiring of equipment to dients. There are many companies in the country, and each company has at least three branches across the country. Where each branch has staff including the branch manager who is responsible for...

  • This is third time im posting this Question COURSE; introduction to database Please, No handwriti...

    This is third time im posting this Question COURSE; introduction to database Please, No handwriting thanks for your efforts Design the database by following . Execute the sample requested queries. . ER Diagram. . All schemas before and after normalization. . All SQL statements of: -Creating tables. - Inserting data in tables. -Queries. 5. Screenshots from MySQL (or any other software you use) Question is - Database system for a Wholesale Management System Consider a database system for a Wholesale...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT