QuestionQuestion

Customer History Form

Customer Name

Jackson, Elizabeth
Phone (206) 284-6783
123 – 4th Avenue
Fonthill, NJ 10234

Purchases Made

Artist, Title, Purchase Date, Sales Price

03 - Carol Channing Laugh with Teeth 09/17/2000    7000.00
15 - Dennis Frings South toward Emerald Sea 05/11/2000    1800.00
03 - Carol Channing At the Movies 02/14/2002    5550.00
15 - Dennis Frings South toward Emerald Sea 07/15/2003    2200.00

1) Bring this document to 3RD Normal Form.

2) Create the Entity Relationship Diagram (ERD) for this application.

3) Create the Data Dictionary for this application.

4) Write the SQL statement to create a table named “Customer” based on the Data Dictionary from item 3.

5) Create a VIEW to allow an employee to generate a list of the Customers and their selection of Artists, Titles and Dates.

6) Create a TRIGGER to track updates on the Customer table.
Track changes made “ONLY ON” the following fields:
Cust_ID, Cust_Name, Cust_Phone, Date_Of_Update, User_ID

7) Define the Data Definition commands and their function.

8) Define the Data Manipulation commands and their function.

9) Describe the Database Life Cycle.

10) Discuss the problems that may occur by not performing regular backups.

Solution PreviewSolution Preview

These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice. Unethical use is strictly forbidden.

    By purchasing this solution you'll be able to access the following files:
    Solution.docx.

    $68.00
    for this solution

    or FREE if you
    register a new account!

    PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

    Find A Tutor

    View available Database Development Tutors

    Get College Homework Help.

    Are you sure you don't want to upload any files?

    Fast tutor response requires as much info as possible.

    Decision:
    Upload a file
    Continue without uploading

    SUBMIT YOUR HOMEWORK
    We couldn't find that subject.
    Please select the best match from the list below.

    We'll send you an email right away. If it's not in your inbox, check your spam folder.

    • 1
    • 2
    • 3
    Live Chats