ASSIGNMENT FOR PRACTICE, Assignments of Database Programming

NORMALIZATION EXAMPLE TO UNDERSTAND AND LEARN NORMALIZATION

Typology: Assignments

2023/2024

Uploaded on 01/17/2024

sameer-sameer-1
sameer-sameer-1 🇵🇰

1 document

1 / 2

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Capital University of Science
and Technology
Department of Software Engineering
SE2313 Database
Systems
ASSIGNMENT NO.
2
Semester: Fall 2023 Max Marks: 10
Instructor: Ms. Itrat Fatima
Assigned Date: 12/01/2024 Due Date:
17/01/2024
Name: Reg. No.
Important Instructions:
1. Title page should be attached at the very front of the assignment
containing Your name, Registration number, etc.
2. Only Handwritten are acceptable.
3. Copied assignment shall be considered rejected and no marks shall be
awarded to all the students having same assignment no matters who
copied.
4. Exact copy from even a website shall not be acceptable.
5. Viva may be conducted after submission of Assignment.
6. Two marks shall be deducted for each day in case of late submission.
Submission beyond 5 days shall mark the assignment zero.
________________________________________________________________________
Assignment 4
Gallery Customer History Form
Customer Name
Jackson, Elizabeth Phone (206) 284-6783
123 4th Avenue
Fonthill, ON
L3J 4S4
pf2

Partial preview of the text

Download ASSIGNMENT FOR PRACTICE and more Assignments Database Programming in PDF only on Docsity!

Capital University of Science

and Technology

Department of Software Engineering

SE2313 – Database

Systems

ASSIGNMENT NO.

Semester: Fall 2023 Max Marks: 10 Instructor: Ms. Itrat Fatima Assigned Date: 12 /01/2024 Due Date: 17/01/ Name: Reg. No. Important Instructions:

  1. Title page should be attached at the very front of the assignment containing Your name, Registration number, etc.
  2. Only Handwritten are acceptable.
  3. Copied assignment shall be considered rejected and no marks shall be awarded to all the students having same assignment no matters who copied.
  4. Exact copy from even a website shall not be acceptable.
  5. Viva may be conducted after submission of Assignment.
  6. Two marks shall be deducted for each day in case of late submission. Submission beyond 5 days shall mark the assignment zero.

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