Skip to content

jhu10/INFO6210_DB_Project

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 

Repository files navigation

2019-Movies-DB

For INFO 6210 Course Project

DB_SQL_Files folder contains 11 SQL text files corresponding to each table in database.

Python_files folder contains three python files for Reddit API, Twitter API and Youtube API respectivley, and explanation.pdf for the three APIs.

Raw data folder contains 11 .csv files for each table. Because the size of Reddit.csv is larger than 25mb, the data is uploaded with a .rar file.

Schema folder contains Conceptual model diagram and EER diagram file.

SQL_Scripts contains three SQL text files--functions, Use cases and Views.

reportDB.pdf is the file to explain the procedure of API and to raise some examples to make movie database into practice.

The test includes the application of functions, stored procedure and SQL cases.

Also, we can see the popular tags and topics that people talk about and comment on to know the trends regarding the movies.

About

No description, website, or topics provided.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published