Проектирование и реализация баз данных и клиентских приложений в среде MS Visual Studio.NET. Макурин Ю.Д - 27 стр.

UptoLike

ВУЗ: 

ПГУ | Пенза

Составители: 

Рубрика: 

27
DEFAULT 'New Position – title not formalized jet',
min_lul tinyint NOT NULL CHECK(min_lul > = 10),
max_lul tinyint NOT NULL CHECK(max_lul < = 250)
)
CREATE TABLE publishers
(pub_id char(4) NOT NULL
CONSTRAINT PKL_pub_id PRIMARY KEY CLUSTERED
CHECK(pub_id IN ('1389', '0736', '0877', '1622', '1756')
OR
pub_id LIKE '99[0-9][0-9]'),
pub_name varchar(40) NULL,
city varchar(20) NULL,
state char(2) NULL,
country varchar(30) NULL DEFAULT('USA')
)
CREATE TABLE employee
(emp_id varchar(20) CONSTRAINT UPK_emp_id PRIMARY KEY
NONCLUSTERED
CONSTRAINT CK_emp_id
CHECK(emp_id LIKE
'[A-Z][A-Z][A-Z][1-9][0-9][0-9][0-9][0-9][FM]'
OR
emp_id LIKE
'[A-Z]-[A-Z][1-9][0-9][0-9][0-9][0-9][0-9][FM]'),
fname varchar(20) NOT NULL,
minit char(1) NULL,
lname varchar(30) NOT NULL,
job_id smallint NOT NULL DEFAULT (1) REFERENCES
jobs(job_id),
job_lul tinyint DEFAULT (10),
pub_id char(4) NOT NULL DEFAULT('9952') REFERENCES
publishers(pub_id),
hire_date datetime NOT NULL DEFAULT(GETDATE())
)
GO 
                            DEFAULT 'New Position – title not formalized jet',
       min_lul tinyint   NOT NULL CHECK(min_lul > = 10),
       max_lul tinyint   NOT NULL CHECK(max_lul < = 250)
      )

      CREATE TABLE publishers
      (pub_id char(4) NOT NULL
                  CONSTRAINT PKL_pub_id PRIMARY KEY CLUSTERED
                  CHECK(pub_id IN ('1389', '0736', '0877', '1622', '1756')
                           OR
                           pub_id LIKE '99[0-9][0-9]'),
       pub_name varchar(40) NULL,
       city      varchar(20) NULL,
       state     char(2) NULL,
       country varchar(30) NULL DEFAULT('USA')
      )

        CREATE TABLE employee
       (emp_id varchar(20) CONSTRAINT UPK_emp_id PRIMARY KEY
                                                             NONCLUSTERED
                    CONSTRAINT CK_emp_id
                    CHECK(emp_id LIKE
                                 '[A-Z][A-Z][A-Z][1-9][0-9][0-9][0-9][0-9][FM]'
                             OR
                             emp_id LIKE
                                '[A-Z]-[A-Z][1-9][0-9][0-9][0-9][0-9][0-9][FM]'),
        fname varchar(20) NOT NULL,
        minit char(1) NULL,
        lname varchar(30) NOT NULL,
        job_id      smallint     NOT NULL DEFAULT (1) REFERENCES
jobs(job_id),
        job_lul tinyint DEFAULT (10),
        pub_id char(4) NOT NULL DEFAULT('9952') REFERENCES
                                                             publishers(pub_id),
        hire_date datetime NOT NULL DEFAULT(GETDATE())
       )

      GO




                                       27

Страницы