Database Management System Assignment, Assignments of Computer science

An assignment for a fundamentals of database systems course at the college of engineering, computer science department. The assignment requires students to provide the normal forms (unf, 1nf, 2nf, 3nf, bcnf) for a customer history database used by the gill art gallery. The gallery maintains data on their customers, artists, and paintings, with paintings being bought and sold multiple times. The assignment has a submission deadline, late submission penalties, and an honor code agreement. A sample customer history form with details such as customer name, address, and purchase information. Analyzing this document could help students understand database normalization principles and their application in a real-world scenario.

Typology: Assignments

2010/2011

Uploaded on 04/07/2023

al-khawlani
al-khawlani 🇶🇦

1 document

1 / 2

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
COLLEGE OF ENGINEERING
COMPUTER SCIENCE DEPARTMENT
CMPS351-L52 Fundamentals of Database Systems
Spring 2023
Assignment-2
Submission deadline: Saturday, April 15th, 2023 (end-of-day, 11:59pm)
Start working on the assignment early. Avoid last minutes submissions. There will be 25% (per day) penalty for late submissions up
to 2 days. No submissions will be accepted after Monday, April 17, 2023 (end-of-day, 11:59 pm)
Important Notes:
1- Submit through Blackboard, NO other means like email, etc., are accepted.
2- Assignments are to be solved individually. You should NOT write up solutions together NOR
copy-and-paste solutions that are not YOURS.
3- Submit your work as instructed below before the deadline.
If you have any uncertainty, questions, or doubts about any of the above, ask your instructor!
Honor Code Agreement
I understand that submitting work that is not my own will result in a “Zero” grade and in
disciplinary action.
pf2

Partial preview of the text

Download Database Management System Assignment and more Assignments Computer science in PDF only on Docsity!

COLLEGE OF ENGINEERING

COMPUTER SCIENCE DEPARTMENT

CMPS351-L 52 Fundamentals of Database Systems Spring 202 3

Assignment- 2

Submission deadline: Saturday, April 15 th, 20 23 (end-of-day, 11:59pm)

Start working on the assignment early. Avoid last minutes submissions. There will be 25% (per day) penalty for late submissions up to 2 days. No submissions will be accepted after Monday, April 17 , 202 3 (end-of-day, 11:59 pm) Important Notes: 1 - Submit through Blackboard, NO other means like email, etc., are accepted. 2 - Assignments are to be solved individually. You should NOT write up solutions together NOR copy-and-paste solutions that are not YOURS. 3 - Submit your work as instructed below before the deadline. If you have any uncertainty, questions, or doubts about any of the above, ask your instructor! Honor Code Agreement I understand that submitting work that is not my own will result in a “Zero” grade and in disciplinary action.

Gallery Customer History Form Customer Name Jackson, Elizabeth Phone (206) 284- 6783 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. Provide UNF, 1NF, 2NF, 3NF, BCNF.