

Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
NORMALIZATION EXAMPLE TO UNDERSTAND AND LEARN NORMALIZATION
Typology: Assignments
1 / 2
This page cannot be seen from the preview
Don't miss anything!


Semester: Fall 2023 Max Marks: 10 Instructor: Ms. Itrat Fatima Assigned Date: 12 /01/2024 Due Date: 17/01/ Name: Reg. No. Important Instructions:
**Assignment 4 Gallery Customer History Form** Customer Name Jackson, Elizabeth Phone (206) 284- 123 4 th^ Avenue Fonthill, ON L3J 4S
Purchases Made Artist Title Purchase Date Sales Price 03 - Carol Channing Laugh with Teeth 09/17/2000 7000. 15 - Dennis Frings South toward Emerald Sea 05/11/2000 1800. 03 - Carol Channing At the Movies 02/14/2002 5550. 15 - Dennis Frings South toward Emerald Sea 07/15/2003 2200. The Gill Art Gallery wishes to maintain data on their customers, artists and paintings. They may have several paintings by each artist in the gallery at one time. Paintings may be bought and sold several times. In other words, the gallery may sell a painting, then buy it back at a later date and sell it to another customer. UNF: 1NF: 2NF: 3NF: