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, which is a generic term. If the part of the cattle, many parts of the meat can be called beef brisket, beef brisket is mainly special
Point is sinews, oil less , even all lean meat. It seems that the study of this system, beef Brisket News system is b/s in the fine
Hua, Classic! Let's start tasting it together.
Ii. the software needed to learn the beef brisket
1, mainly to install VS and database sql
2. Other software:
Dreamweaver Flash PhotoShop
3, Browser: IE, opera, chroma, 360 browser (posted in these places to be able to make)
4. UML Drawing tools: EA or Jude
Third, UML diagram
Press release system is mainly two runner, browser and background administrator, so there is a uml diagram of it as follows:
1. Use case diagram "Browse by":
2, use case diagram "Backstage Manager":
3. Class Diagram:
Third, the establishment of the database
According to the preceding entity, the class diagram establishes three tables, establishes the new project, the source code is as follows:
--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 ( C13/>id int Identity (primary) key, [content] text NOT NULL, createtime datetime NOT NULL, Userip varch AR (+) not NULL,)
The effect is as follows:
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 review, draw UML diagram, set up a database and so on. "Cattle
Belly News System "of more wonderful still in the back Oh, please attention and guidance.
Beef Brisket News System (i)--UML, database design