Lecture 6

Announcements
--------------

- Looking for a new group or other active members? Let me know.
- Internet problems? 


Topics for today:
---------------------
Fourth Normal Form
ER Diagrams


Potential Databases:
---------------------
Movies
AirBnb
Lyft
NetFlix
ClimateData
Instagram
Olympics
RickandMorty
Jeopardy
HeroUniverse

-------

Is it an entity or an attribute?
   -- If more than one entity will refer to it with a relationship, then
   use an entity

-------

ClimateData
    MeasurementType  key: mtype, unit
    Stations:  key:id, latitude, longitude
    Measurements: key: id, value


Stations may instruments for different measurement types

AirBnB


NetFlix
   Pictures: (Id), pictureFile
   TVShows:  (Id), Name, ReleaseYear, ChannelName, Description
   Episodes: (Id), SeasonNumber, Number, Name, ReleaseDate    
   Movies: (Id), Name, ReleaseYear, Description
   Genres: (Name)
   Actors: (Id), Stage Name, Real Name, DateofBirth
   Subscribers: (UserId), Email, Password, CCNo, CVC, Address, LastPaymentDate
   Profiles: (ProfileName), WhenCreated, ProfilePicture

   ProfileRatings: (id), rating
   ProfileWatchHistory: (id), date
   ProfileWatchList: (id), dateadded, rank

** Trailers?
   
Lyft