1 / 11

Database of favorite TV show episodes

David Lloyd December 15, 2011. Database of favorite TV show episodes . Project Scenario. This is a database that consists of TV show episodes. In this database it consists of the following attributes E pisodes Shows Actors Directors C haracters. Project Scenario (cont).

jalena
Download Presentation

Database of favorite TV show episodes

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. David Lloyd December 15, 2011 Database of favorite TV show episodes

  2. Project Scenario • This is a database that consists of TV show episodes. In this database it consists of the following attributes • Episodes • Shows • Actors • Directors • Characters.

  3. Project Scenario (cont) • Contains 6 tables: • tbl_episode • tbl_show • tbl_director • tbl_actor • tbl_character • tbl_name

  4. Episode/Shows ERD Diagram

  5. Episode/Shows ERD Diagram (3NF defense) • All attributes in table are dependent to primary key • Tables have unique records listed in each table

  6. Episode/Shows ERD Diagram (3NF defense) Things to note: • Previous table could be further broken down if database had a need for it Examples would include: • Parental Ratings • Audio Format

  7. Security Plan • Users and access privileges

  8. Security Plan (cont) • Backup and recovery plan • Backups will occur nightly in the case of a disaster the recovery will grab the previous nights backup any data after that will be lost. • Minor Damageif only the partial system is down but communication lines are still open then the goal would be to move the applications from the system unavailable • Major Damagethe entire system is down as are the communication and network. The goal would be to move the entire system to the standby facility.

  9. Hardware/Software requirements (End Users)

  10. Applicability of Dimensional Warehouse Structure • This plan for this database is feasible on a smaller scale however if you created a website with many users it would consist of expanding in many areas from hardware, software, table structures, and also staff.

  11. QUESTIONS ?

More Related