PROJECT (1) - SETNAMGROUPS CTUREEND_REQUEST FI RST_NAM...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
ER DIAGRAM PASSWORD USER_NAME USER EMAIL_ID PHONE_NO LOCATION NAME PROFILE_ID LAST_NAME FIRST_NAME DATE_OF_ BIRTH COUNTRY STATE CITY LANGUAGE P_ID USER_NAME FRIEND_NAME FRIENDLIST USER_NAME FRIEND_REQUEST INVITE_ FRIEND SETS GROUPED_INTO COMMENTS UPLOAD RECEIVER_ NAME GROUP_ID ARE_ MEMBERS_ OF PICTURE IMAGE P_ID GROUP_NAME PICTURE_ NAME OWNER GROUPS CONTAINS TIME-DATE AUTHOR DESCRIPTION GROUP_ID MEMBERS CATEGORY SET_ID SETNAME COP5725 DATABASE MANAGEMENT SYSTEMS PROJECT DELIVERABLE 1 PHOTOGRAPHY SOCIAL NETWORK - CONCEPTUAL DESIGN
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
TABLE OF CONTENTS 1. E-R DIAGRAM 1 2. TABLE SPECIFICATION 2 3. DATABASE CONNECTIVITY CODING 6
Background image of page 2
A
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
TABLE SPECIFICATION: MySql is used as the database engine and PHP/IIS for the web part. Six tables are defined. The MySQL coding for the creation of the tables are as follows. mysql> create database dbms; Query OK, 1 row affected (0.00 sec) mysql> use dbms; Database changed mysql> create table user_details -> ( -> user_name varchar(25) primary key, -> password varchar(8) not null, -> first_name varchar(20), -> last_name varchar(20), -> dob date, -> city varchar(20), -> state varchar(20), -> country varchar(20), -> zip int(10), -> phone_no int(10), -> email varchar(25), -> language varchar(20) -> ); Query OK, 0 rows affected (0.04 sec)
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 11/21/2010 for the course CS 5725 taught by Professor A.dobra during the Fall '10 term at University of Florida.

Page1 / 10

PROJECT (1) - SETNAMGROUPS CTUREEND_REQUEST FI RST_NAM...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online