UML class diagram

[mswanson-mscst]

After the team has completed the consolidated class worksheet/user stories document, each team member should individually create a conceptual class diagram using Visual Paradigm. Post a screenshot of your class diagram here.

[justin-sultze-mscs]

Here's my conceptual class diagram

[jseppa-mscs]

[ummer-siddique-mscs]

[mswanson-mscst]

I'm working on getting the movie/actors data that we'll need for the application, and found that the IMDb webapi has very limited search features. They have a lot of data available for download, though, so I made a recording that shows the procedure I used for downloading the text files from IMDb and importing the data into SQL Server:

2754 2020 031 IMDb download, import https://mediaspace.minnstate.edu/media/2754+2020+031+IMDb+download%2C+import.mp4/1_rnipfb6u

Hopefully, by tomorrow I'll have a cleaned up version of the database that you can work with in getting started on the project.

[mswanson-mscst]

I'm putting the finishing touches on the IMDb database that I imported. The movie genre information wasn't normalized, and it's taking a long time to create the m:n table between movies and genres. For a preview, here's the current structure:

The two most important tables are:

• title_basics: contains basic information about each movie
• name_basics: contains names of all artists (actors, directors, etc.)

I'll post the database files in D2L tomorrow morning so you can download them to your machine. The sample data includes roughly:

• 38,000 movies (nothing current - mostly pre-1940's)
• 4,000,000 names (actors, directors, etc.)
• 25 genres
• 10 artist categories (actor, director, etc.)

I'll also post the Model classes that EF generated from the database. They should give you a head start.