Please enable JavaScript.
Coggle requires JavaScript to display documents.
Streaming Service Database - Coggle Diagram
Streaming Service Database
Functionality
Main Menu
Program
Search
Search textbox
Drop down box with different columns for searching in
Movies
Genre
Streaming Service
ID number
Update
Update selected Data with inserted information via textbox
Insert
Multiple textbox labelled with their corresponding column specified for the table that the information is being insetrted into
Confirm Insertion button
Delete
Delete Entire row
Row selection required
Delete Entire Column
Textbox asking for column name
Confirmation Screen Appears
Row or column Deleted
Settings
Font Size
Small
Medium
Large
User
Targeted Audience
Likes Movies and TV Shows
The program is designed for all Ages
Simple understanding of technologies required to navigate the interface
Hardware/Software
Databasing
SQL Lite
Back end Programming
C#
SQL Lite API
XAML
Front end Programming
XAML
Data Requirements
Movies Table
Movie Name
String
Primary Key
Unique
Not Null
Genre
String
ID Number
Foreign Key
Unique
Integer
Not Null
Director
String
Release Date
String
Streaming Service Table
Streaming Service
String
Not Null
Movie Name
String
Unique
Not Null
ID Number
Primary Key
Integer
Unique
Not Null
IMDB Ranking
Foreign Key
Unique
Not Null
Integer
Reviews Table
Reccommended Age
Integer
IMDB Ranking
Primary Key
Unique
Integer
Not Null
Rotten Tomatoes Score
Integer
Not Null
Movie Name
Foreign Key
String
Not Null
Unique