|
Assignment 2 -- Design a Database (Part 1 of 6)
|
|
In this assignment you will design a relational MySQL database to perform
the following function:
|
|
**NOTE** This assignment is intended to be a team
assignment and is preferred, however, it is optional and you can do this
as an individual project.
This is the first part of a multi-part lab project that you will
create in this class. Subsequent labs will introduce the other
parts (there is nothing stopping you from looking ahead to get a
feel for what they are)
Your teams should be of either 3 or 4 people. You are expected
to meet in a group-type environment
|
You have been contacted by a nation wide analytics firm. They want
you to design a database that can track information about people for
the purpose of creating a profile of each person in the database.
The analysis from this database will be used for target marketing
campaigns.
|
Requirements:
- (Core) -- The database will maintain core identity information
on all entries, however, the database will maintain the ability
to build a core identity when information on a target is sparse
- (Input) -- The database will be able to handle data farmed from
social media platforms like Fakebook, Twit-terd, Insta-slam, etc
- (Output) -- The database will be able to handle a variety of
products, services or opinions for which we can track the
preferences of each person in the database based on analyzing
their data
|
|
Variable timing (more time spent on the first part) results in less
time spent on the second part (1 hour each), however, not spending time
on the first part can result in lots of additional time re-visioning
the last part (10 minutes on part 1, 10 hours on part 2)
|
