Java Web project Combat record (database table design)

I'm busy at this point again.

Although tired, but look at their own projects at 1.1 points of growth, the heart full of sense of accomplishment >_<

Today, in the afternoon of the CEP (workplace Social etiquette Planning course), is not the workplace as the CEP teacher said that the intrigue it?

So today did not do a lot of things, the database document has come out, but is not too detailed, the relationship between the table is not too clear (the design of the database I did not participate)

Here is the documentation for the database:

--------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------

Database of Student Information management system

System Overview:

Different from the previous small class, now there are more than 80 students in the class, if you use the traditional Excel tools to edit the student data, the efficiency will be very low, so the database for data editing. Improve efficiency. At the same time better with the UI linkage.

Purpose of writing:

1. This database design book is about student information Management system database design, mainly including data logical structure design

2. This database design manual is mainly for: users, System Designers, system testers, system maintenance personnel.

3. This database design book is based on the requirements of the system design prepared

Background:

In order to use computer technology to manage student information, because Computer Management has: fast detection, easy to find, high reliability, storage capacity, confidentiality, low cost, long life and other advantages.

Demand:

① teacher through the account password login management system to view and modify the basic information of students, including age classes, guardian contact, home address, etc.

② students can log in through their account password, check their test scores and other information, and change the password.

Database software: Oracle

Tablespace Name: Stu

The following tables are set according to the requirements:

Naming convention: All database naming is the abbreviation of the module plus the English vocabulary of the specific table, so that the name of the Unified database table, but also better to standardize the database table naming.

User table (user name, password)

Student table (name, gender, school number (username), age, ID number, telephone, school, professional, email, entry time, working status)

Dictionary table (type number, type name, type classification)

Family table (number, name, relationship, ethnicity, telephone, hometown (province, city, county))

Location information table (location number, name, parent number)

Users (user table)

Field name	Specific parameters	Description description
User_name	Number	User name
PASSWORD	Number	Password

Students (Student table)

Field name	Specific parameters	Description description
SNAME	NVARCHAR2 (50),	Name
SSEX	Number,	Gender
Sid	Number NOT NULL	Study number (user name)
Age	Number,	Age
Id_card	NVARCHAR2 (100)	ID number
Tel_phone	NVARCHAR2 (100),	Phone
SCHOOL	NVARCHAR2 (100),	School
Magor	Number,	Professional
EMAIL	NVARCHAR2 (150),	Mailbox
Enter_date	DATE,	Admission Time
Work_state	NVARCHAR2 (50),	Working status

DICTIONARY (dictionary table)

Field name	Specific parameters	Description description
d_id	Number is not NULL,	Type number
D_name	VARCHAR2 (+) NOT NULL,	Type name
D_type	Number	Type classification

FAMILY (Family information Sheet)

Field name	Specific parameters	Description description
f_id	Number is not NULL,	Number
F_name	NVARCHAR2 (Ten) is not NULL,	Guardian
F_relation	NVARCHAR2 (10),	Relationship
F_nativeplace	Number,	National
F_phone	NVARCHAR2 (11),	Phone
F_add_province	Number	Province
F_add_city	Number,	City
F_add_county	Number	County

Location (Position information table)

Field name	Specific parameters	Description description
location_id	Number NOT NULL	Location number
Location_name	NVARCHAR2 (30),	Location name
father_id	NVARCHAR2 (30),	Parent number

--------------------------------------------------------------------------------------------------------------- -----------------------------------------------------------------------------------------------------------

In five tables, the remaining four tables are constrained by the student table (Studet) as the foreign key

Tonight's a night of tangled JSP

Alas, the heart is tired

Tomorrow, write some JSP stuff.

-------may there be someone to shelter you from the way you go

2017-8-16 23:30

Good night, world.

Java Web project Combat record (database table design)