CSCI 6370 database project

By: B. J. Wimpey and Jed Hassell

Part 1 - The E/R Diagram!

The Relational Schema * updated *

Actor(actorName, DOB, startDate, chrName)
Award(type, episodeTitle)
character(chrName, occupation, website)
Episode(title, season, productionCode, airDate, director, writer)
Season(year, numOfEpisodes, executiveProducer)
Simpsons_Family_Member(chrName)
School_Mate(chrName)
Work_Mate(chrName)
Springfield_Retirement_Castle_Occupent(chrName)
Director(dirName)
Directs(dirName, episodeTitle)
Learns_with(simpsonName, schoolMateName)
Works_with(simpsonName, workMateName)
Retirement_castle_member_with(simpsonName, castleMemberName)
Voices(actorName, chrName)
characterIn(chrName, episodeTitle)
episodeOf(episodeTitle, seasonYr)

The Ontology Diagram

The Details

Our database will consist of detailed information about the exquisite animated television show, The Simpsons. Why is such a database important? The Simpsons have been around for over fifteen years and have acquired a fanatic fanbase of millions. To converge valuable information on this popular T.V. show into a single, searchable, and user-friendly database would be extremely valuable, not just to the fans of the show, but to the followers of all revolutionary T.V. shows. An end user will be able to search the database based on such criteria as characters, voice-actors, writers, directors, episodes, seasons, awards, and more! We envision our interface to use a searchable text box to link to the database (a.k.a. query-based design).