Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Create the tables per conceptual design, named - CUSTOMER - WORK - TRANS - ARTIST 2. Create association table for CUSTOMER to ARTIST,

1. Create the tables per conceptual design, named - CUSTOMER - WORK - TRANS - ARTIST 2. Create association View Ridge Gallery Data Model CUSTOMER Email Address LastName FirstName Encrypted Password Street City State 1) Populate tables with data - Insert at least 5 artists Insert at least 15 artworks - Insert at least 10 

1. Create the tables per conceptual design, named - CUSTOMER - WORK - TRANS - ARTIST 2. Create association table for CUSTOMER to ARTIST, named CUSTOMER ARTIST_INTEREST 3. Create surrogate keys as needed for each table 4. Link table relationships using primary and foreign keys 5. Add new attributes to table(s) to support the business 6. Produce Physical Database Diagram from MS SQL Server - View Ridge Gallery Data Model CUSTOMER Email Address LastName FirstName Encrypted Password Street City State ZIPorPostalCode Country AreaCode PhoneNumber PURCHASES/SOLD TO Ho TRANS DateAcquired Acquisition Price Asking Price DateSold SalesPrice ACQUIRED WORK Title Copy +H Medium Description HAS INTEREST IN/ADMIRED BY CREATES/CREATED BY HH nn NIU ARTIST LastName FirstName Nationality DateOfBirth DateDeceased 1) Populate tables with data - Insert at least 5 artists Insert at least 15 artworks - Insert at least 10 customers - Insert at least 15 transactions - Insert at least 20 interests - 2) Create 5 original SQL queries to analyze all data Use joins, subqueries, and/or aggregate functions 'Select * from customer' does not count!!! Display the results in a human readable format Column choice, ordering should be considered - NIU

Step by Step Solution

There are 3 Steps involved in it

Step: 1

I can provide you with an outline of the tasks detailed in your questions and the corresponding SQL DDL Data Definition Language commands to create th... 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

Recommended Textbook for

Concepts of Database Management

Authors: Philip J. Pratt, Mary Z. Last

8th edition

1285427106, 978-1285427102

More Books

Students also viewed these Databases questions

Question

=+a) What kind of study was this?

Answered: 1 week ago

Question

How do you join tables in SQL?

Answered: 1 week ago