Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(20 pts) Map the Art Museum ERD to relational schema and implement the database in MySQL with data from your research. ART Museum ERD Requirements:

  1. (20 pts) Map the Art Museum ERD to relational schema and implement the database in MySQL with data from your research.

ART Museum ERD

image text in transcribed

Requirements:

  • There should be at least 5 art objects and at least 2 tuples in each relation.
  • Null values are allowed but majority of the cells should not be null.

Deliverables (Submit the following in one zip file):

  1. A picture of relation schema (PK & FK with arrows, hand drawing accepted)
  2. A .sql file with all the CREATE TABLE and INSERT INTO statements
  3. ONE picture of all the data like the sample submission, preferably as a result of SELECT * FROM instead of screenshots of spreadsheets. CountryBom Died Main Syle Dales Artist Height Styles Statue Creatcs Style Art Object Type dNo Year Title Other DeseniptionS

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions