Submitted by: Submitted by kanniewong
Views: 374
Words: 1233
Pages: 5
Category: Business and Industry
Date Submitted: 12/01/2010 07:37 AM
EECS 484 F10 Project 1 – Database Design for Facebook
Due: October 1, 2010 by 11:59PM Overview
In Project 1, you will design a relational database for storing information about your Facebook social network. You will begin with a detailed description of the content. Then, you will need to systematically go through the conceptual and logical database design process you learned about in class.
Part 1. ER Design
As a starting point, we have done the initial “requirements analysis” for you. The following is a brief description of the data that you will store in your database. (In real life, you would ordinarily begin with much fuzzier information.) User Information There can be an unlimited number of users. Each user has the following information: 1.1 Profile information This includes the following attributes: first name, last name, year of birth, month of birth, date of birth, gender. 1.2 Hometown Location A user’s hometown includes the following attributes: city, state, country. 1.3 Current Location Exactly the same attributes as hometown location. 1.4 Education History Education history is for college programs and above. A user could have participated in multiple such programs, and each one will have the following attributes: name of the institution (e.g., University of Michigan), year of graduation, concentration (e.g., CS, EE, etc.), and degree (e.g., BS, MS, PhD, etc.). 1.5 Friendship information Each user can have any number of friends. Each friend must also be a Facebook user. Photos “Photos” is an important Facebook application. Each photo has the following associated information:
1
2.1 Album information Each photo MUST belong to an album. An album has the following associated attributes: album_ID, owner_ID (this refers to the owner’s Facebook ID), album_name, cover_photo_ID (this refers to a photo ID), album_created_time, album_modified_time , album_link and album_visibility. 2.2...