Book Management system use case Diagram Book Management program (i)

Source: Internet
Author: User
The structure of the data table used by this level program:
# --------------------------------------------------------
#
# The structure of the data table ' author '
#
CREATE TABLE Author (
author_id Int (6) DEFAULT ' 0 ' not NULL auto_increment,
first_name varchar () binary not NULL,
last_name varchar () not NULL,
Address varchar (+) binary not NULL,
ZipCode varchar (ten) is not NULL,
Telephone varchar (ten) is not NULL,
Email varchar (not NULL),
Comment varchar (255) is not NULL,
PRIMARY KEY (author_id),
KEY first_name (first_name),
KEY last_name (last_name),
KEY address,
KEY ZipCode (ZipCode),
KEY Email (email)
);
# --------------------------------------------------------
#
# The structure of the data table ' books '
#
CREATE TABLE Books (
books_id Int (6) DEFAULT ' 0 ' not NULL auto_increment,
Books_name varchar (+) binary not NULL,
publisher_id varchar (6) Not NULL,
date_pub datetime DEFAULT ' 0000-00-00 00:00:00 ' not NULL,
Type varchar (6) is not NULL,
Pages varchar (4) Not NULL,
Price Float (6,2) The DEFAULT ' 0.00 ' not NULL,
Comment varchar (255) binary not NULL,
ISBN varchar (+) not NULL,
PRIMARY KEY (books_id),
KEY name (Books_name),
KEY Publisher (publisher_id),
KEY date_pub (date_pub),
KEY Price,
KEY pages (pages),
KEY type (type),
KEY ISBN (ISBN)
);
# --------------------------------------------------------
#
# The structure of the data table ' Books_author '
#
CREATE TABLE Books_author (
ID Int (6) DEFAULT ' 0 ' not NULL auto_increment,
books_id varchar (6) Not NULL,
author_id varchar (6) Not NULL,
Author_type varchar (6) Not NULL,
PRIMARY KEY (ID)
);
# --------------------------------------------------------
#
# The structure of the data table ' publisher '
#
CREATE TABLE Publisher (
publisher_id Int (6) DEFAULT ' 0 ' not NULL auto_increment,
Publisher_name varchar (+) binary not NULL,
Address varchar (+) is not NULL,
ZipCode varchar (ten) is not NULL,
Telephone varchar (ten) is not NULL,
telefax varchar (ten) is not NULL,
Email varchar (not NULL),
PRIMARY KEY (publisher_id),
KEY name (Publisher_name),
KEY address,
KEY Email (email)
);

The above describes the book management system use case diagram of the book Management Program (a), including the book Management system use case diagram of the content, I hope that the PHP tutorial interested in a friend helpful.

  • Contact Us

    The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

    If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

    A Free Trial That Lets You Build Big!

    Start building with 50+ products and up to 12 months usage for Elastic Compute Service

    • Sales Support

      1 on 1 presale consultation

    • After-Sales Support

      24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.