1. Create the tables per conceptual design, named - CUSTOMER - WORK - TRANS - ARTIST...

   

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

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... View the full answer