Beef Brisket News System (i)--UML, database design

     Beef Brisket News System (i)--UML, database design


First, the initial knowledge of beef brisket system

Beef Brisket (brisket) is the soft muscle in the abdomen and near the rib of the ox, which refers to the meat with ribs, meat and youhua.

Block. This is a generic term.

If the location of the cattle, many parts of the meat can be called beef brisket, beef brisket mainly special

Point is sinews, oil less , even all lean meat. It seems that the study of this system. Beef Brisket News System is the fine in B/s

China. Classic!

Let's start with the tasting.

Second, the need for learning beef brisket software

1, mainly to install VS and database sql

2. Other software:

Dreamweaver Flash PhotoShop

3, Browser: IE, opera, chroma, 360 browser (published in these places to be able to make)

4. UML Drawing tools: EA or Jude

 


Third, UML diagram

The press release system is mainly two performers, the browser and the background administrator, so there are UML diagrams like the following:

1. Use case diagram "Browse by":

2, use case diagram "Backstage Manager":

3. Class Diagram:

    

Third, the establishment of the database

Build three tables based on the previous entity, Class diagram, create a new project, SQL source code such as the following:

--Create Database newssystem--1, set up Category table CREATE TABLE category (   ID int identity (primary) key,   [name] varchar () not NULL     )--2, creating news Table CREATE TABLE news (  ID int identity (primary) key,  title varchar (+) not Nu ll,   [content] text NOT NULL,   createtime datetime NOT NULL,   caId int   )--3, build Comment table create TABLE comment (  ID int identity (primary key),   [content] text NOT NULL,   createtime datetime NOT NULL,   Userip varchar (+) NOT NULL,   newsId int)

effects such as the following:


1. Category List


 


2. News sheet:


 


3. Comment form:


 


Summary:

These are mainly some very basic knowledge, but I still want to do a small summary of the stage, on their own

Learn and Grow of a real record. The beef brisket is a project of B/s After the C/S project, the first B/s system, but

in front of these mainly back to the C/s before some of the review or recall. Draw UML diagrams, build databases, and so on.

"Cattle

Belly News System "of many other wonderful still behind Oh, please attention and guidance.

Beef Brisket News System (i)--UML, database design