Speciality. :
| () | NULL | ||
| Num | int | ||
| Name | varchar(60) |
. , ( ). ( - int). - , varchar(60). . .
MS SQL Server Management Studio ( > .). :
6.
Num ( ), int. , null. , , null. :
7.
, Num . :
8.
Speciality ( ). ( ):
9.
, ( ), . , . , (. 10):
10.
4. SQL-
, , , . (, IBM DB2) . SQL , , .
:
11.
.
CREATE DATABASE mbs21_query
F5. ( , ).
Speciality. :
|
|
|
CREATE TABLE < > (
< 1> < > [NOT NULL] [DEFAULT < >],
< 2> < > [NOT NULL] [DEFAULT < >],
...
)
:
/* */
USE mbs21_query -- ,
CREATE TABLE Speciality(
Num INT IDENTITY(1,1) PRIMARY KEY NOT NULL, --
NameSpec VARCHAR(60) --
)
, . SQL- ( , , ). IDENTITY(1,1) , Num (, ).
. Course.
Course ()
| () | NULL | ||
| Num | int | ||
| Name | varchar(60) | ||
| YearEntry | int | ||
| YearFinal | int | ||
| Speciality | ( Speciality) | int |
Speciality, Speciality. , :
/* */
USE mbs21_query -- ,
CREATE TABLE Course(
Num INT IDENTITY(1,1) PRIMARY KEY NOT NULL, --
YearEntry INT NOT NULL, --
YearFinal INT, --
Speciality INT FOREIGN KEY REFERENCES Speciality(Num) -- ,
-- Num Speciality
)
. . ( ).
. , , SQL .
.
Speciality ()
| () | NULL | ||
| Num | int | ||
| Name | varchar(60) |
Course ()
| () | NULL | ||
| Num | int | ||
| Name | varchar(60) | ||
| YearEntry | int | ||
| YearFinal | int | ||
| Speciality | ( Speciality) | int |
Group ()
| () | NULL | ||
| Num | int | ||
| Name | varchar(60) | ||
| Course | ( Course) | int |
Discipline ()
| () | NULL | ||
| Num | int | ||
| Name | ( : , ) | varchar(60) |
Account ( )
|
|
|
| () | NULL | ||
| Num | int | ||
| Name | ( : , , ) | varchar(30) |
Mark ()
| () | NULL | ||
| Num | int | ||
| Name | ( : , , , ) | varchar(30) | |
| Value | ( : 0, 1, , 5) | int |
Status ( )
| () | NULL | ||
| Num | int | ||
| Name | ( : , , , ) | varchar(60) |
Position ()
| () | NULL | ||
| Num | int | ||
| Name | ( : , , ) | varchar(60) |
People ()
| () | NULL | ||
| Num | int | ||
| LastName | varchar(30) | ||
| FirstName | varchar(30) | ||
| MiddleName | varchar(30) | ||
| Male | char(1) | ||
| BrthDate | datetime | ||
| Addr | varchar(100) |
Student ()
| () | NULL | ||
| Num | int | ||
| People | ( People) | int | |
| Group | ( Group) | int | |
| StudNum | varchar(30) | ||
| Status | ( Status) | int |
Teacher ()
| () | NULL | ||
| Num | ( ) | int | |
| People | ( People) | int | |
| Position | ( Position) | int |
SemesterResults ( )
| () | NULL | ||
| Num | int | ||
| Student | ( Student) | int | |
| Semester | int | ||
| Account | ( Account) | int | |
| Discipline | ( Discipline) | int | |
| Teacher | ( Teacher) | int | |
| Mark | ( Mark) | int | |
| Date | DateTime |
MS SQL Server 2005-8?
MS SQL Server 2005-8?
?
?
Not Null?
