View source for ClapperBoard via WordPress - Buse Akin

= '''<center>ClapperBoard</center>''' =
=. Project Scope=
*This project will consists of a website based on movies. The project will have a platform for users to create their own movie watch lists, and they will have an option to like, share, and edit these customized movie lists in order keep it up with current and old movies. This project will be completed by May, 2016.

=. Introduction=
==. Goals and Objectives==
*There are lots of movie-rating websites in the world wide web, however none of those are useful to make lists, share ideas and interact with other users. The prior research showed that people, who loves watching movies, are in need of a platform or application which will provide lists of movies that they liked or lists of movies that they want to see. On '''ClapperBoard''' people can log in to website, create their own watchedlist and watchlist, rate the movies, share their lists, see other user’s lists, search the movies or directors, and they can see categorized movies with genres. There will be also a notification system to let users know about upcoming movies according to their selections. ClapperBoard is going to be a platform which every movie addicts want to join.

==. Statement of Scope==
*The inspiration for '''ClapperBoard''' is from Leonardo Da Vinci's famous quote; ''“Simplicity is the ultimate sophistication.”''. Website will be minimal and effective for the users. All they need to do is register and enjoy the website. There will be two default list which are watchedlist and watchlist. They can easily add or delete movies to the lists, they can add date to remember when they watched the movie or when they will watch the movie. There will be share buttons to share the lists they like, spoiler buttons to make sure comments can readable.

==. Major Constraints==
*At the creation stage, timing will be very important for this project. The main goal is to finish the development in the beginning of April and then the plan is to move to the test stage. 
*Design phase is crucial. This website cannot be complicated with lot of colors, buttons etc. It should be simple, because there will be a lot of movies, movie pictures, information, etc.
*Database design is another important point of this project. In order to receive data faster, design should be on point. All the relationship between entities should be correct, as well as proper usage of integrity.

=. Technical Details=
==. Technologies I use==
*'''Platforms:'''
**MySQL Workbench
**WordPress
**Erwin for Data Modeling

*'''Languages:'''
**PHP
**MySQL
**HTML
**CSS
=. Database Design and Description=
==. Introduction==
*The first thing to do in order to create database, is to complete data modeling. In Data Modeling, the job is to take the requirements and begin to design a rough plan or layout for the requirements. There are several phases of design to create a model before implementation. Before project, blueprints helps to find and plan out the overall design of the project. Creating rough sketches and designs can provide new information as well. During the project having a data model is useful for project tracking and scheduling the project. Data Modeling contains three steps. These are Conceptual, Logical and Physical Phases.
===. Conceptual Phase===
*Conceptual phase is the first step in the data modeling. In conceptual phase, overall goal is to design a basic simplified overview of the project. At this point, the restrictions are not taking into account. Conceptual phase provides a good understanding of the concept as a whole. There is only information about entities and the relationship in between entities. The picture below shows the entity relationship diagram for the conceptual phase.


[[File:Conceptual.png]] <br>


*'''The entities in this design are;'''
**	Movies; this entity will store basic movie information. It has a many-to-many relationship with ‘Director’ entity.
**	Conjunction MD; this entity will ensure the many-to-many relationship between ‘Movies’ and ‘Director’.
**	Director; will store basic information about directors.
**	List Detail; this entity will hold specific movie information in the ‘List Detail’ entity.
**	Movie List; this entity will hold the information about movie lists, which are created by users.
**	Users; will store basic information about users.
**	Liked List; this entity will hold the specific list information that one users liked.

===. Logical Phase===
*Logical phase is the second step in data modeling. In logical phase, user requirements are taken into account, thus provides a clear view of the restrictions. It is overall logical understanding of the concept. In logical phase, attributes, primary keys, foreign key should be represented as well as entity names and entity relationships. The picture below shows the entity relationship diagram of logical phase.


[[File:Logical.jpg]] <br>

===. Physical Phase===
*The third and final phase of data modeling is the physical phase. In physical phase, technical restrictions applied to the design from logical phase. This final phase provides overall physical structure of the database, that is the final blue prints. 
At this stage in the project, the physical phase is still on process. The final table names should be decided, as well as column names and column types. Thus requires more time to do the proper analysis. 
Implementation and population of database with sample data can only start after finalizing the data modeling.

=. Flow Diagrams=
[[File:Flow.jpg]]

=. WebSite Navigation= 
'''BURAYI DÜZENLE'''
==. WelcomePage==
*There will be log in and register section. In this section users can log in or they can register a new account.
*The search box will provide an option for user to search movies or director, by name or by year.
*In the main section, there will be some popular lists and some information about upcoming movies. 
*There is going be interactive menu for users to create new movie lists or modify already existing ones.

==. HomePage==
*In home page, each user can see other users', which they liked, movie lists.
*User can share other lists or can make a comment in the home page.
*There will be option for users to create new list or modify already existing ones.
*Users can modify user information.

==. MyLists==
*In the Mylists Page, there will be 2 default lists ; watched list and watchlist. 
*Watched list will contain movies that user had already watched and liked to work as a guidance for other users. They can also add the date they watched, their comments on specific movie, and the rate that they gave.
*Watch list will contain movies that user wants to see. They can also set a time frame as a remainder.

==. Explore==
*There will be explore section to popular movies, shared lists, new released movies, etc.

==. SearchBar==
*There will be search bar in every page for users to search a director or a specific movie.
*They can search a movie by year or by movie name.
*To search a director, users can use first name, middle name, or last name of the director.

==. EditPage==
*Users can modify their information.
*There will be section for notifications.
*Finally there will be a logout segment.

=. Project Schedule=
For the ClapperBoard website project, there are some stages;<br>
'''1.''' Project Analysis (4-5 weeks) <br>
'''1.1''' Project Design (3-4 weeks)<br>
'''2.''' Database Design (3-4 weeks)<br>
'''2.1''' Finalize Database Design (last 1 week of DB Design)<br>
'''3.''' Coding<br>
'''3.1''' Implementation ( starts same time with Finalize Database Design)<br>
'''3.2''' Front End Development (2 weeks)<br>
'''3.3''' Sample Database Population ( starts same time with Front End Development 2 weeks)<br>
'''4.''' Testing (takes 2-3 weeks)<br>
'''5.''' Finalize Project<br>
'''5.1''' Finalize Project with the Test Results (takes 2 weeks)<br>
'''5.2''' Addind missing data/content (takes 1 week)<br>
[[File:Gantt.jpg]]

=. Weeks=
'''BURAYI DÜZENLEMEN LAZIM'''
==I.Week==
*Name of the project is determined.
*Logo was created.
[[File:Clapperboard.png]]

==II.Week==
==III.Week==
==IV.Week==
==V.Week==
==VI.Week==
==VII.Week==
==VIII.Week==

=. Risk Management=
== .Project Risks==
According to the schedule, this project should be done in the first week of May. Although, some problems might occur during analysis and development. In case of any problem, there might be a change in schedule in order to fix everything.<br>
*Some problems might happen due to the server.
*There might be some legal issues as well, specially with IMDB. Also, there might be copyright issues with movies, movie production companies, directors, actors, etc.
*Security is another risk that project has. Especially with user loggings, their passwords must be encrypted with the correct algorithm, in order to prevent their privacy. Need to prevent possible hackings.
*Browser problems might happen due to the layout of wordpress. The layouts and design might change according to the browsers. 
*Some extensions in wordpress, might not be compatible with the other extensions.

=. Developer=
==. Contact Information==

'''Name:''' Buse AKIN<br>
'''Responsibility:''' Front End Develeoper & Database Designer<br>
'''Phone Number:''' 607 338 0140<br>
'''E-mail Address:''' bakin2@binghamton.edu<br>