Answered step by step
Verified Expert Solution
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 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...Get Instant Access to Expert-Tailored 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