1.1 Data Entry Forms
1.2 Reports
1.3 Input output screen //not going to worry about this
1.4 Make a list of 10 assumumptions

Art Gallery Example
1. In future we will be having other people doing some of the interviewing
2. Each work is a unique peice
3. Artists have unique names
4. If you get money then you need SSN
Class two is killing class one, in the lead!
5. Combination of work and title are unique
6. works can be returned
7. Artists can have multiple work
8. WOrk can be owned by a collector or artist
9. if owned by collector the artist name needs to be kept
10. Payment is made at time of purchase


What you see at an art gallery
wood cuts, sculputes, screen prints, paintings, lithographs

Photo Project Assumptions
1. The payments aren't going to be full
2. It is possible to request a photographer
3. Customer can buy multiple packages

University
1. Payments need to be equal payments if monthy
2. All events have a single coorinador

Auto
1. Vechile ID is unique
2. Car trade-ins are one car at a time
3. Only one make of cars
4. Take any model
5. deal may or not give license plate

Medical
Absent

Theater
1. Actor can be in more than one play
2. Actor can have a couple parts

Data Dictionary For art gallary
|->List of all attributes likely to be in the database and a description

** SEE SLIDES FOR COMPLETE LIST **

ArtistDateOfInterview
ArtistInterviewerName
ArtistLastName
ArtistFirstName
ArtistStreet
ArtistCity
ArtistState
ArtistZip
ArtistTeleAreaCode
ArtistTeleNumber
ArtistSSN
ArtistType
ArtistMedium
ArtistStyle

ArtworkTitle
ArtworkArtistName
ArtworkMedium
ArtworkType
ArtworkStyle
ArtworkAskingPrice
ArtworkDateListed
ArtworkSellPrice
ArtworkSellingDate
ArtworkSellingPrice
ArtworkDateReturned
ArtworkDateShown
ArtworkOwnersLastName
ArtworkOwnersFirstName
ArtworkOwnersStreet
ArtworkOwnerPhone
ArtworkOwnerAreaCode
ArtworkOwnerState
ArtworkOwnersZip
ArtworkOwnerSSN

BuyersStreet
BuyersPhone
BuyersAreaCode
BuyersState
BuyersZip
BuyersSSN

Somethings in the datadictionary are things that can be computed.

Charicteristics of relations -> unique rows, order of rows and columns not important, cannot have multiple values in the cell of a relation

Quiz on all words from the slide

** See slides for explination of normal forms **

MultiValued dependincies **figure 3-18**
     |-> Multiple values dependant on a single attribute

**figure 3-19** has two multivalued dependencies

**figure 3-20** has a multivalued dependency and functional dependency