FPT – Aptech Computer Education

ohiofulvousΛογισμικό & κατασκευή λογ/κού

15 Αυγ 2012 (πριν από 5 χρόνια και 2 μήνες)

316 εμφανίσεις

FPT


Aptech Computer Education

eProject


1

Group1_C0712I









Cooking Online

Documentation








HDSE Group1_C0712I

Group Member

Mau Tien Doan

Bui Dinh Duong

To Hong Lien

Lam Thi Trang

Instructor

Do Quoc Binh





-

Hanoi, 08/2010

-

FPT


Aptech Computer Education

eProject


2

Group1_C0712I


Table of Contents

Problem Definition
................................
................................
................................
..........................

3

1.1.

Problem Abstraction

................................
................................
................................
.........

3

1.2.

The Current System

................................
................................
................................
..........

3

1.3.

The Proposed System

................................
................................
................................
.......

3

1.4.

Boundaries of the System

................................
................................
................................
.

3

1.5.

Development Environment

................................
................................
..............................

3

2.

Requirements and Business Flow

................................
................................
............................

4

2.1.

Customer Requirement Specification
................................
................................
...............

4

2.2.

Activity Diagram

................................
................................
................................
..............

5

2.3.

Use

Case Diagram

................................
................................
................................
............

6

2.4.

Use Case Specification

................................
................................
................................
.....

9

3
.

Design

................................
................................
................................
................................
....

24

3.1.

System Architecture

................................
................................
................................
.......

24

3.2.

Entity Relationship Diagram

................................
................................
..........................

25

3.3.

Database Design

................................
................................
................................
.............

25




FPT


Aptech Computer Education

eProject


3

Group1_C0712I


Problem Definition

1.1.

Problem Abstraction

James Thew is one of the famous cook working in one of the five star hotels in the city.
He is so famous that the publishers approach him to wri
te recipes book, and provide some of the
tips pertaining to the recipes, etc. Also some of the producers want him to work for their recipe
shows where he needs to cook two or three recipes of different categories like juices, non
-
vegetarian and vegetarian
recipes, Italian recipes, etc.

1.2.

The Current System

He actually loves cooking, and during his free time he spends his time by cooking and
trying out new recipes that he had come across. He also wanted to conduct the cookery classes
and share his recipes
where he can interact with different people and can get their feedback. So
he has started the classes near by his home, as a part
-
time job during the weekends, where people
used to attend for learning the different varieties of recipes from him. He general
ly charges with
very less fares for these weekend classes, so as to attract the maximum number of people to the
classes.


1.3.

The Proposed System

Now Mr. James is thinking to have a website of his own where he can input the recipes
on it, so as to reach out to

a maximum number of people across the world. So he has approached
us with his ideas, and he wants us to help him by creating the website as per his requirements.


1.4.

Boundaries of the System

a.

Admin

-

Login System.

-

Display Personal details.

-

Insert, update, delete, search
recipe, tips,
contests, Announcements.

b.

Member

-

Login System.

-

Display Personal details,

-

View, search

recipe, tips,
contests
.

-

Update, delete the recip
es, tips that has sent.

c.

Guest

-

Registry members.

-

View, search recipes and the
tips that are free.

-

View and participate in the contests
.

1.5.

Development Environment

a.


Hardware Requirements:

-

Pentium IV CPU 2.80 GHz

-

512 MB of RAM of higher

FPT


Aptech Computer Education

eProject


4

Group1_C0712I


-

Hard disk requirement : Minimum 4 GB

-

Window 2000 or XP or higher.

b.

Soft ware Requirements:

-

Netbeans
IDE 6.9.

-


JDK 1.6.

-

SQL Server 2005

-

Internet Explorer 7.0 or higher of or other web browser as Firefox
.


2.

Requirements and Business Flow

2.1.

Customer Requirement Specification

a.

The main menu of the website should include the following.

-

Home Page describing about

the owner (Mr. James Thew)

-

Login Page or Register Page. Over here the customer can register with the site
provided he makes the payment. The payment for the member ship can be one of the
following ways.

(A)

Monthly Subscription


10$

(B)

Yearly Subscription


100
$

-

Free Recipes (One should be able to view the recipes that are listed as free and give
their feedbacks, and for viewing this one need not get registered with the site)

-

View and participate in the contests

-

Announcements (Here one can view the winners of th
e latest contest that is held and
announced by the site owner (James)).

-

Feedback (the feedback about the views related to the site)

-

FAQ’s

b.

On the home page the details of the client should be provided.

c.

The site owner can place a contest as per his
requirements, where he can ask the users to
post a recipe or post the tips. The one with the best will be receiving the price. Once the
recipes and tips are posted, Mr. James will announce the winner after reviewing each of
them.

d.

Once the admin or owner or

Mr. James logs into the site, the following menu should
appear



Home Page



User Profile (Here the profile of the user is to be displayed. In this page itself the
user should be able to edit the profile).



Should have access to all the cookery recipes on the
site.



View and search the recipes and tips online.



Can view all the feedbacks received for recipes.



Post new contests or remove the contests.



View the posts (Here Mr. James should be able to view the posts (recipes or tips
as applicable to the contest) rec
eived with respect to the contest).



Announcements (On this page Mr. James can announce the winners of the
contest)



Upload tips.

FPT


Aptech Computer Education

eProject


5

Group1_C0712I




Upload recipes along with the list of the ingredients and the cooking procedures.



Mr. James can mark the tips and the recipes po
sted by him, as either free or
available to the members of the site only



Should be able to view or update or delete the tips and recipes that he has
uploaded on the site.



FAQ’s

e.

Once the user logs into the site, the following menu should appear



Home Page



U
ser Profile (Here the profile of the user is to be displayed. In this page itself the
user should be able to edit the profile).



Should have access to all the cookery recipes on the site.



View and search the recipes and tips online.



Can view the announcemen
ts made by the owner.



Can send a feedback for a recipe.



View and Participate in the contests



Send the tips



Send the recipes along with the list of the ingredients and the cooking procedure



View the recipes and tips that are sent by all the customers of the

site.



Should be able to view or update or delete the tips and recipes that he/she has
sent.

f.

FAQ’s

g.

For the general user, who is not the member of the site, the following functionalities are
to be provided.



Home Page



Can register with the site on the
Login/Register Page



Should be able to view and search the recipes and tips online on the free recipes
alone, but can have access to only the cookery recipes and the tips that are
available as free on the site.



Should be able to view and Participate in the
contests by sending the tips and the
recipes along with the list of the ingredients and the cooking procedure



Can view the announcements made by the site owner.



Can send a feedback for a recipe.



FAQ’s

h.

The FAQ’s Page will have the following questions, alon
g with their answers.



How to become the member of this site?



Will there be any subscription charges?



How to view the recipes and tips? Will there be any charges for that?



I am not the registered member of the site. Can I participate in the contest held?



Ho
w to upload or post the recipes and tips?



How to post a feedback?



I have posted a recipe or a tip with respect to the contest. How can I know who is
the winner?

2.2.

Activity Diagram


FPT


Aptech Computer Education

eProject


6

Group1_C0712I


2.3.

Use Case Diagram

a.

Recipes Management


b.

Tips Management

FPT


Aptech Computer Education

eProject


7

Group1_C0712I



c.

Contest Management

FPT


Aptech Computer Education

eProject


8

Group1_C0712I




d.

Member Management

FPT


Aptech Computer Education

eProject


9

Group1_C0712I



2.4.

Use Case Specification

2.4.1.

Recipes Management

a.

Add new recipes


USE CASE #

UC01_01

USE CASE Name

Create new recipes

ACTOR

Admin

Purpose

Add new information to the System

Preconditions

Admin
login


Post conditions in words

A new
recipes is added to the System

Trigger

Admin enable function add new
recipes

Extended Use Cases


MAIN SUCCESSFUL
SCENARIO

Actor Action

System Action

1.

Admin access system
select function recipes
management




2
. System display function
user
management

3.

Admin select function
Add new recipes



4.

Form Add new is display

5.
Admin enter information
into form add new recipes



FPT


Aptech Computer Education

eProject


10

Group1_C0712I


6.

Click Button Submit




7.

System processing
information and then saved
to the database

OTHER SUCCESSFUL
SCENARIOS

Step

Branching Action

UNSUCCESSFUL
SCENARIOS

Conditions

Actions

6a.

When you click the
button submit,

inspection
data is invalid

Display warning, check
information until valid data
is transferred to the next
step

Developer

LienTH

Creation
date and last
modified date

18/11/2010



b.

Edit recipes


USE CASE #

UC01_02

USE CASE Name

Edit
recipes Information

ACTOR

A
dmin

Purpose

Edit information recipes in System

Preconditions

Admin
login

to the System

Post conditions in words

R
ecipes
information will be update add new information

Trigger

Admin enable function Edit recipes information

Included Use Cases

Search
Recipes

Extended Use Cases


MAIN SUCCESSFUL
SCENARIO

Actor Action

System Action

1.

Admin access system
select function recipes
management.



2
. System display function
recipes management.

3.

Admin select search
function recipes needs
change



4.

System display recipes
information to needs
change

5.

Admin change recipes
information


6.

Admin click button Edit



7.
System processing
information was change
FPT


Aptech Computer Education

eProject


11

Group1_C0712I


then saved to the database

OTHER SUCCESSFUL
SCENARIOS

Step

Branching Action

UNSUCCESSFUL
SCENARIOS

Conditions

Actions

6a.

When you click
the
button edit, inspection data is
invalid

Display warning, check
information until valid data
is transferred to the next
step

Developer

LienTH

Creation date and last
modified date

08/11/2010



c.

Delete recipes


USE CASE #

UC01_03

USE CASE Name

Delete
Recipes Information

ACTOR

Admin

Purpose

Delete information recipes

Preconditions

Admin
login

to the System

Post conditions in words

One or more recipes will be removed from the System

Trigger

Admin enable function Delete recipes information

Included Use Cases

Search
Recipes

Extended Use Cases


MAIN SUCCESSFUL
SCENARIO

Actor Action

System Action

1.

Admin access system
select function recipes
management



2.

System display function
recipes management

3.

Admin select search
function recipes needs delete



4.

System display recipes
information to needs delete

5.

Admin Click Button
Delete



6.

The System display a
message asking Admin
select Yes or No

7.
Admin conduct selection



8.

System remove
recipes

information in database


End Use Case

OTHER SUCCESSFUL
Step

Branching Action

FPT


Aptech Computer Education

eProject


12

Group1_C0712I


SCENARIOS

5a.

Admin click button yes

System processing
information was removed
then saved to the database

5b.

Admin click button no

System exit delete function
then back the recipes
management.

UNSUCCESSFUL
SCENARIOS

Conditions

Actions

Developer

LienTH

Creation date and last
modified date

08/11/2010


d.

Search recipes


USE CASE #

UC01_04

USE CASE Name

Search Recipes Information

ACTOR

Admin

Purpose

Search
recipes Information

Preconditions

Admin
login

to the System

Post conditions in words

System display recipes information needs search

Trigger

Admin enable function Search recipes information

Extended Use Cases


MAIN SUCCESSFUL
SCENARIO

Actor Action

System Action

1.

Admin access system
select function recipes
management



2.

System display function
recipes management

3.

Admin recipes search
function



4.

System display recipes
information to needs search


End Use Case

OTHER SUCCESSFUL
SCENARIOS

Step

Branching Action

UNSUCCESSFUL
SCENARIOS

Conditions

Actions

Developer

LienTH

Creation date and last
modified date

08/11/2010


2.4.2.

Tips

Management

a.

Add new Tips


USE CASE #

UC02
_01

FPT


Aptech Computer Education

eProject


13

Group1_C0712I


USE CASE Name

Create new Tip
s

ACTOR

Admin

Purpose

Add new
information to the System

Preconditions

Admin
login


Post conditions in words

A new tip
s is added to the System

Trigger

Admin enable function add new
tip
s

Extended Use Cases


MAIN SUCCESSFUL
SCENARIO

Actor Action

System Action

1.

Admin access system
select function
tip
s
management




2
. System display function
tip
s management

3.

Admin select function
Add new
tip
s



4.

Form Add new is display

5.
Admin enter information
into form add new
tip
s



6.

Click Button Submit




7.

System processing
information and then saved
to the database

OTHER SUCCESSFUL
SCENARIOS

Step

Branching Action

UNSUCCESSFUL
SCENARIOS

Conditions

Actions

6a.

When you click the
button submit, inspection
data is invalid

Display warning, check
information until valid data
is transferred to the next
step

Developer

LienTH

Creation date and last
modified date

18/11/2010



b.

Edit Tip
s


USE CASE #

UC02
_02

USE CASE Name

Edit
tips

Information

ACTOR

Admin

Purpose

Edit information
tip
s in System

Preconditions

Admin
login

to the System

Post conditions in words

Tip
s

information will be update add new information

Trigger

Admin enable function Edit
tip
s

information

Included Use Cases

Search
Tip
s

FPT


Aptech Computer Education

eProject


14

Group1_C0712I


Extended Use Cases


MAIN SUCCESSFUL
SCENARIO

Actor

Action

System Action

1.

Admin access system
select function
tip
s

management.



2
. System display function
tip
s

management.

3.

Admin select search
function
tip
s

needs change



4.

System display
tip
s

information to needs
change

5.

Admin change
tip
s

information


6.

Admin click button Edit



7.
System processing
information was change
then saved to the database

OTHER SUCCESSFUL
SCENARIOS

Step

Branching Action

UNSUCCESSFUL
SCENARIOS

Conditions

Actions

6a.

When you click the
button edit,
inspection data is
invalid

Display warning, check
information until valid data
is transferred to the next
step

Developer

LienTH

Creation date and last
modified date

08/11/2010



c.

Delete
Tips


USE CASE #

UC02
_03

USE CASE Name

Delete
Tips

Information

ACTOR

Admin

Purpose

Delete information
tip
s

Preconditions

Admin
login

to the System

Post conditions in words

One or more
tip
s

will be removed from the System

Trigger

Admin enable function Delete
tip
s

information

Included Use Cases

Search
Tips

Extended Use Cases


MAIN SUCCESSFUL
SCENARIO

Actor Action

System Action

1.

Admin access system
select function
tip
s


FPT


Aptech Computer Education

eProject


15

Group1_C0712I


management


2.

System display function
tip
s

management

3.

Admin select search
function
tip
s

needs delete



4.

System display
tip
s

information to needs delete

5.

Admin Click Button
Delete



6.

The System display a
message asking Admin
select Yes or No

7.
Admin conduct selection



8.

System remove
tip
s

information in database


End Use Case

OTHER SUCCESSFUL
SCENARIOS

Step

Branching Action

5a.

Admin click button yes

System processing
information was removed
then saved to the database

5b.

Admin click button no

System exit delete function
then back the
tips

management.

UNSUCCESSFUL
SCENARIOS

Conditions

Actions

Developer

LienTH

Creation date and last
modified date

08/11/2010


d.

Search
Tips


USE CASE #

UC02
_04

USE CASE Name

Search
Tips

Information

ACTOR

Admin

Purpose

Search
tip
s

Information

Preconditions

Admin
login
to the System

Post conditions in words

System display
tip
s

information needs search

Trigger

Admin enable function Search
tip
s

information

Extended Use Cases


MAIN SUCCESSFUL
SCENARIO

Actor Action

System Action

1.

Admin access system
select function
tip
s

management



2.

System display function
tip
s

management

FPT


Aptech Computer Education

eProject


16

Group1_C0712I


3.

Admin
tip
s

search function



4.

System display
tip
s

information to needs search


End Use Case

OTHER SUCCESSFUL
SCENARIOS

Step

Branching Action

UNSUCCESSFUL
SCENARIOS

Conditions

Actions

Developer

LienTH

Creation date and last
modified date

08/11/2010


2.4.3.

Contest Management

a.

Add New Contest

USE CASE #

UC03
_01

USE CASE Name

Create new
Contest

ACTOR

Admin

Purpose

Add new information to the System

Preconditions

Admin
login


Post conditions in words

A new

contest

is added to the System

Trigger

Admin enable function add new
contest

Extended Use Cases


MAIN SUCCESSFUL
SCENARIO

Actor Action

System Action

1.

Admin access system
select function
contest

management




2
. System display function
contest

management

3.

Admin select function
Add new
contest



4.

Form Add new is display

5.
Admin enter information
into form add new
contest



6.

Click Button Submit




7.

System processing
information and then saved
to the database

OTHER SUCCESSFUL
SCENARIOS

Step

Branching Action

UNSUCCESSFUL
SCENARIOS

Conditions

Actions

6a.

When you click the
button submit, inspection
data is invalid

Display warning, check
information until valid data
is transferred to the next
step

FPT


Aptech Computer Education

eProject


17

Group1_C0712I


Developer

LienTH

Creation
date and last
modified date

18/11/2010



b.

Edit
Contest


USE CASE #

UC02
_02

USE CASE Name

Edit
C
ontest

Information

ACTOR

Admin

Purpose

Edit information
contest

in System

Preconditions

Admin
login

to the System

Post conditions in words

Contest

information will be update add new information

Trigger

Admin enable function Edit
contest

information

Included Use Cases

Search
Contest

Extended Use Cases


MAIN SUCCESSFUL
SCENARIO

Actor Action

System Action

1.

Admin access system
select function
contest

management.



2
. System display function
contest

management.

3.

Admin select search
function
contest

needs
change



4.

System display
contest

information to needs
change

5.

Admin change
contest

information


6.

Admin click button Edit



7.
System processing
information was change
then saved to the database

OTHER SUCCESSFUL
SCENARIOS

Step

Branching Action

UNSUCCESSFUL
SCENARIOS

Conditions

Actions

6a.

When you click the
button edit, inspection data is
invalid

Display warning, check
information until valid data
is transferred to the next
step

Developer

LienTH

Creation date and last
modified date

08/11/2010


FPT


Aptech Computer Education

eProject


18

Group1_C0712I



c.

Delete
Contest


USE CASE #

UC02
_03

USE CASE Name

Delete
Contest

Information

ACTOR

Admin

Purpose

Delete information
contest

Preconditions

Admin
login

to the System

Post conditions in words

One or more
contest

will be removed from the System

Trigger

Admin enable function Delete
contest

information

Included Use Cases

Search
Contest

Extended Use Cases


MAIN SUCCESSFUL
SCENARIO

Actor Action

System Action

1.

Admin access system
select function
contest

management



2.

System display function
contest

management

3.

Admin select search
function
contest

needs delete



4.

System display
contest

information to needs delete

5.

Admin Click Button
Delete



6.

The System display a
message asking Admin
select Yes or No

7.
Admin conduct selection



8.

System remove
contest

information in database


End Use Case

OTHER SUCCESSFUL
SCENARIOS

Step

Branching Action

5a.

Admin click button yes

System processing
information was removed
then saved to the database

5b.

Admin click button no

System exit delete function
then back the
contest

management.

UNSUCCESSFUL
SCENARIOS

Conditions

Actions

Developer

LienTH

Creation date and last
modified date

08/11/2010


d.

Search Contest

FPT


Aptech Computer Education

eProject


19

Group1_C0712I



USE CASE #

UC03
_04

USE CASE Name

Search
Contest

Information

ACTOR

Admin

Purpose

Search
contest

Information

Preconditions

Admin
login
to the System

Post conditions in
words

System display
contest

information needs search

Trigger

Admin enable function Search
contest

information

Extended Use Cases


MAIN SUCCESSFUL
SCENARIO

Actor Action

System Action

1.

Admin access system
select function
contest

management



2.

System display function
contest

management

3.

Admin
contest

search
function



4.

System display
contest

information to needs search


End Use Case

OTHER SUCCESSFUL
SCENARIOS

Step

Branching Action

UNSUCCESSFUL
SCENARIOS

Conditions

Actions

Developer

LienTH

Creation date and last
modified date

08/11/2010



2.4.4.

Member

Management

a.

Add New Member


FPT


Aptech Computer Education

eProject


20

Group1_C0712I


USE CASE #

UC04_01

USE CASE Name

Add New
Member

ACTOR

Customer

Purpose

Add new information to the System

Preconditions


Postconditions in words

A new
Member

is added to the System

Trigger

Customer

enable function add new Customer

Extended Use Cases


MAIN SUCCESSFUL
SCENARIO


Actor Action

System Action

1.

Customer

access
system select function

Member

management




2.

System display function
Member

management

3.

Customer

select
function Add
Member



4.

Form Add new is display

5.

Customer

enter
information into form
add new
Member


6.

Click Button Submit




7.

System processing information
and then saved to the database

OTHER
SUCCESSFUL
SCENARIOS

Step

Branching Action

UNSUCCESSFUL
SCENARIOS


Conditions

Actions

6a.

When you click the
button submit,inspection
data is invalid

Display warning, check
information until valid data is
transferred to the next step

Developer

LienTH

Creation date and last
modified date

08/11
/2010


B. Edit
Member
Information


FPT


Aptech Computer Education

eProject


21

Group1_C0712I


USE CASE #

UC04
_02

USE CASE Name

Edit
Member

ACTOR

Member

Purpose

Edit
Member

in System

Preconditions

Member

login

to the System

Postconditions in words

Member

information will be update add new
information

Trigger

Member

enable function Edit
Member

Extended Use Cases


MAIN SUCCESSFUL
SCENARIO


Actor Action

System Action

1.

Member

access system
select function
Member

management



2
. System display function
Member

management

3
.

Member

change
Member

information


4
.

Member

click button
Edit



5
.

System processing
information was change
then saved to the database


End Use
Case

OTHER
SUCCESSFUL
SCENARIOS

Step


Branching Action



UNSUCCESSFUL
SCENARIOS


Conditions

Actions

3
a.

When you click the
button edit,

inspection
data is invalid

Display warning, check
information until valid data
is transferred to the next
step

Developer

LienTH

Creation date and last
modified date

08/11
/2010




C. Delete
Member

Information


FPT


Aptech Computer Education

eProject


22

Group1_C0712I


USE CASE #

UC04
_03

USE CASE Name

Delete
Member

Information

ACTOR

Admin

Purpose

Delete
Member

information

Preconditions

Admin
login

to the System

Postconditions in words

One or more
member

will be removed from the System

Trigger

Admin enable function Delete
member

information

Included Use Cases

Search
member

Extended Use Cases


MAIN SUCCESSFUL
SCENARIO


Actor Action

System Action

1.

Admin access system
select function
member

management



2.

System display function
member

management

3.

Admin select search
function
member

needs
delete



4.

System display
member

information to needs
delete

5.

Admin Click Button
Delete



6.

The System display a
message asking Admin
select Yes or No

7.
Admin conduct selection



8.

System remove
member

information in
database


End Use Case

OTHER
SUCCESSFUL
SCENARIOS

Step

Branching Action

5a. Admin click button yes

System processing
information was removed
then saved to the database

FPT


Aptech Computer Education

eProject


23

Group1_C0712I


5b. Admin click button no

System exit delete
function then back the
member

management

UNSUCCESSFUL
SCENARIOS


Conditions

Actions



Developer

LienTH

Creation date and last
modified date

08/11
/2010



D. Search
Member


USE CASE #

UC04
_04

USE CASE Name

Search
Member

ACTOR

Admin

Purpose

Search
Member

Information

Preconditions

Admin
login

to the System

Postconditions in words

System display
Member

information needs search

Trigger

Admin enable function Search
Member

information

Extended Use Cases


MAIN SUCCESSFUL
SCENARIO


Actor Action

System Action

1. Admin access
system select function
member

management



2. System display function
member

management

3. Admin use search
function



4. System display
member

information to needs search


End Use Case

OTHER
SUCCESSFUL
SCENARIOS

Step

Branching Action

3a. Click button search

System display
member

information to needs
search.

FPT


Aptech Computer Education

eProject


24

Group1_C0712I


3b. Click button close

System exit search function
then back the
member

management



UNSUCCESSFUL
SCENARIOS


Conditions

Actions



Developer

LienTH

Creation date and last
modified date

08/11
/2010


3.

Design

3.1.

System Architecture



FPT


Aptech Computer Education

eProject


25

Group1_C0712I


3.2.

Entity Relationship Diagram


3.3.

Database
Design

Table
Permission

Column

Data type

Description

PermissionID

int

PK

Permission
Name

Nvarchar(50)

Not null

Description

Nvarchar(500)

Not null



Table
Users

Column

Data type

Description

User
ID

int

PK

UserName

Nvarchar

Not null

Password

Nvarchar

Not null

FullName

Nvarchar(100)

Not null

Address

Nvarchar(300)


FoneNumber

Varchar(15)


Email

Nvarchar(100)

Not null

Status

Bit

Default True

CreateDate

Datetime

Not null

PermissionID

Int

FK to table Permission

Image

Nvarchar(300)



FPT


Aptech Computer Education

eProject


26

Group1_C0712I



Table
Category

Column

Data type

Description

Category
ID

int

PK

CategoryName

Nvarchar(100)

Not null

Description

Nvarchat(500)




Table
RegisterType

Column

Data type

Description

RegisterType
ID

int

PK

TypeName

Nvarchar(100)

Not null

Cose

Float

Not
null

NumberDay

Int

Not null



Table
Account

Column

Data type

Description

Account
ID

int

PK

UserID

Int

FK to table Users

RegisterTypeID

Int

FK to Table RegisterType

StartDate

Datetime

Not null

EndDate

Datetime

Not null



Table
FAQ

Column

Data type

Description

FAQ
ID

int

PK

AdminID

Int

FK to table Users

QuestionName

Nvarchar(100)

Not null

Answer

Nvarchar(max)

Not null



Table
Contest

Column

Data type

Description

Contest
ID

int

PK

ContestName

Nvarchar(200)


StartDate

Datetime

Not null

EndDate

Datetime

Not null

Requires

Nvarchar(max)

Not null

AdminID

Int

FK to table Users

Prize

Float

Not null

Status

Bit

Default True


FPT


Aptech Computer Education

eProject


27

Group1_C0712I



Table
Recipes

Column

Data type

Description

Recipes
ID

int

PK

CategoryID

Int

FK to table Category

FoodName

Nvarchar(200)

Not null

PostDate

Datetime

Not null

Ingredients

Nvarchar(max)

Not null

Status

Bit

Default True

UserID

Int

FK to table Users



Table
ContestParticipation

Column

Data type

Description

Recipes
ID

int

FK to Recipes

ContestID

Int

FK to table Contest
(PK)

JoinDate

Datetime

Default: getdate



Table
FeedBack

Column

Data type

Description

FeedBackID

Int

PK

UserID

Int

FK to table Users

Contents

Nvarchar(max)

Not null

PostDate

Datetime

Not null

AnswerContents

Nvarchar(max)


Status

Bit

Default
True

AnswerDate

Datetime


RecipeID

Int

FK to table Recipe



Table
Tip

Column

Data type

Description

TipID

Int

PK

TipName

Nvarchar(200)

Not null

Status

Bit

Default: True

RecipeID

Int

FK to table Recipe

PostDate

Datetime

Not null

UserID

Int

FK
to table Users

Contents

Nvarchar(max)




Table
Winner

Column

Data type

Description

FPT


Aptech Computer Education

eProject


28

Group1_C0712I


ContestID

Int

FK to table Contest (PK)

UserID

Int

FK to table Users (PK)

Status

Bit

Default: True

PrizeName

Nvarchar(200)

Not null

ReceiveDate

Datetime

Not null



Project Ref. No.:

Project
Title:

Activity
Plan
Prepared
By:

Date of Preparation of Activity Plan:


Sr.No.

Task

Actual

Start Date

Actual
Days

Team
Member
Names

Status

1

Task

Sheet

Cookin
g






2

eProject
Analysis

08/06/2010

10

Lien


3

Data
Abstraction

08/06/2010

2

All


4

Normalize
database

08/09/2010

1

Doan,
Duong


5

Problem
definition

08/06/2010

1

Lien


6

Customer
Requirement
Specification





7

Architecture
& Design of
the Project





8

Data flow
Diagram





9

Entity
Relationship
Diagram





10

Database
Design
Structure





11

Repair and
Fix





12

Repair and
Complete





13

eProject
Design





14

Develope





15

Testing






FPT


Aptech Computer Education

eProject


29

Group1_C0712I