Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Aug 26, 2024

Design an E-R Diagram for an Art Gallery. Gallery keeps information about: Artist their Name(unique), Phone, Address, Birth place, Age & Style of Art, Art

Design an E-R Diagram for an Art Gallery. Gallery keeps information about:

Artist their Name(unique), Phone, Address, Birth place, Age & Style of Art,

Art Work, Artist, the year it was made, Unique title, Type of art & Prices

Customer, Customer Number, Phone Art preferences

Work of Art, type, artist, date of creation if known (can be NULL), date acquired by gallery, location (Blue Room, Front Room, Basement, etc.)

Types include

Surrealism. ...

Conceptual Art. ...

Pop Art. ...

Photorealism. ...

Hyperrealism. ...

Minimalism. ...

Religious

Works of 19th century

Still Life

Pottery

Sculpture

Note* ER must be done with Microsoft Visio.

Thanks

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Get Instant Access with AI-Powered Solutions

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

Step: 2

Step: 3

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

Question

1. PTSD used to be considered an anxiety disorder. In DSM-5, however, PTSD is placed in a different category of disorders called trauma-related disorders. Why was PTSD reclassified in this manner?

Answered: 1 week ago

Question

★★★★★

A company has the following data: net sales, $405,000; cost of goods sold, $220,000; selling expenses, $90,000; general and administrative expenses, $60,000; interest expense, $4,000; and interest...

Answered: 1 week ago

Question

★★★★★

19 Problem 15-22 The income statement of Stuart Company is shown below: STUART COMPANY Income Statement For the Year Ended December 31, 20X0 Sales Cost of goods sold Gross profit Operating expenses...

Answered: 1 week ago

Question

★★★★★

Business analysis can be defined as the set of tasks and techniques used to work as a liaison among stakeholders in order to understand the structure, policies and operations of an organization and...

Answered: 1 week ago

Question

★★★★★

Israeli container ship operator ZIM Shipping is turning its small size into an advantage in a business dominated by outsize carriers running megaships in global supply chains, writes The Wall Street...

Answered: 1 week ago

Question

★★★★★

Portions of the financial statements for Peach Computer are provided below PEACH COMPUTER Income Statement For the year ended December 31, 2018 Net sales $1.975,000 Expenses Cost of goods sold...

Answered: 1 week ago

Question

★★★★★

Use the following information to answer the next question. The diagram shows a pendulum bob that has been pulled to the right by an angle e. Diagram is not to scale. 3. The pendulum has a length of...

Answered: 1 week ago

Question

★★★★★

Problem 1 (adapted) Abigail Corporation is a distributor of a sun umbrella used at resort hotels. Data concerning the next month's budget appear below: Selling Price P25 per unit Variable expense P15...

Answered: 1 week ago

Question

★★★★★

you have to choose from the give 4 optionsaccounts payableaccounts receivableadvertising expensecash Machinery and Equipment Repair Service is owned by William Giese. Use the above figures to prepare...

Answered: 1 week ago

Previous Question Next Question