• General over view:
Pick a project of your interest from https://www.kickstarter.com/ (Links to an external site.)
The goal of this part of term project is just to pick a project from the kickstarter, submit the url and topic of that project and discuss it with the rest of class during lecture next week ( week 4) . So you just let others know what topic you picked and why that topic was interesting to you by sharing your screen ( each team one person) and elaborate about your selection for a minute.
The goal of entire project is to model a database of at least 6 entities for that project ( more info will be given on this in lecture)
Examples of some of the deliverable you will need to complete, over the course of multiple milestones, by end of semester on your term project:
• Establish at least one 1:1 relationship
• Establish at least 1:M relationship
• Establish at least M:M relationship ( considering normal forms etc in your design)
• Write at least 20 queries to leverage all you have learned in this class by the end of due date of this project (SELECT, UNIQUE, PRIMARY KEY, constrains, anomalies, ..)
• In your design you need to force 1:1 for the 1:1 you are establishing
• In your design you need to apply constraints
• You need to take care of delete, update, etc anomalies
• You need to practice normal forms
• You need to display relationships on ERDs
• For each table you need to make at least 3 entries ( 3 records for each table, sometimes you need to enter more depending on your design )
• you need at least a table to store user credentials. The passwords have to be hashed..
• …
• …
• more …
Deliverable:
In a PDF file ( LastName1_lastName2_ Topic.pdf)
Please post the title of your selected project, RUL:
•
Term Project- Milestone 1 (Finalized project title + tentative name of tables and columns )
General overview:
Pick a project of your interest from https://www.kickstarter.com/ (Links to an external site.)
The goal of entire project is to model a database of at least 6 entities for that KickStarter project. (In the past majority of the teams used more that 6 tables in practice , it is up to your team)
Deliverable:
In a PDF file ( LastName1_lastName2_ Milestone_1.pdf)
Names (your names ( as appears on canvas) with your student ID number)
Title (Title of the project)
URL (URL of the project)
( 2 marks) list the name of entities ( at least 6 tables) you are modeling, the columns names* ( with data type) followed by one short paragraph explaining what that entity (table) stores/does.
You need at least 4 columns for each table
Example:
Entity 1: Customer
customer (
primary_key_column datatype,
… ,
PRIMARY KEY(primary_key_column)
);
Description: e.g Models customers who are going to buy this product. It does not include the admin
Example 2:
Project (
id INT,
title VARCHAR(255) NOT NULL***,
…
…
);
Remarks:
*Note 1: Its ok to change columns of your entities in future, it does not have to be your final schema. We just want to have some ideas of what you are going to design.
**Note 2: Its ok not to pick the right datatype at this moment, just pick your best guess
***Note 3: no need to worry about “not null” etc at this moment. Those are optional for this submission
– no need to share the ERD ( no need to provide me with screenshot of your tables at Workbench, phpMyAdmin etc at this moment)