Who will help me with a database course design? 200

Introduction] This book provides examples of database course design in the context of the development of library management systems. Combined with the actual situation of the library management system, the book introduces in detail the whole process of database structure design, the use of MySQL database, and the design of database applications based on ODBC. The appendix describes the use of SQL Server and JDBC programming techniques

This book can be used as a supplementary textbook for undergraduate students to study databases, and can also be used as a reference material for college students and other readers learning database technology. .

Catalog Information] Chapter 1 Overview.

Chapter 2 Database Design.

Requirements analysis. Mission Overview.

Description of requirements. Data flow diagrams.

Data Dictionary. Database conceptual design.

Local conceptual pattern design.

Global conceptual schema design.

Database logical design.

Selection of DBMS.

Data model mapping.

Database structure optimization and integrity design.

Database physical design.

Chapter 3 Database Use and Management.

Introduction to MySQL.

MySQL installation.

See the detailed catalog.

We're too, the teacher asked me to do this, and I want who to have it, 100,000 urgent.

Thank you for your email.

Modern database systems are an ever-evolving category, and it's integration.

Traditional relational database technology and new computer technology to adapt to modern engineering applications, so as to form a new type of database collection.

The full and effective management and utilization of various information resources in databases is a prerequisite for scientific research and decision-making management. Database technology is the core part of various information systems such as management information system, office automation system, decision support system, etc., and is an important technical means for scientific research and decision-making management.

Database system (DBS) refers to the system after the database is introduced into the computer system, which is generally composed of a database, a database management system (DBMS), application development tools, an application system, a database administrator (DBA) and a user.

The database is where the data is put -- and that's what I realize.

Syllabus.

Overview of the syllabus.

Chapter 1 Introduction.

Chapter 2 Relational Databases.

1.Basic requirements for system functionality:

Product warehousing management, you can fill in the warehousing form to confirm the product warehousing;

For product outbound management, you can fill in the outbound form and confirm the outbound management;

Loan management, with the loan of the note, and then be able to return the library;

Initial inventory setting, set the initial value of the inventory, and the upper and lower warning limits of the inventory;

It can be inventoried to reflect the inventory situation of each month and year;

You can query the warehousing situation, outbound situation, and current inventory situation of the product, and you can query the warehousing order, warehousing order, product and time;

2. Database requirements: The database should contain at least the following data tables:

Inventory Table;

Outbound list table; Inbound list table;

Outbound ledger; warehousing ledger;

IOU information table, reflect, lender, loan time, loan product, loan quantity, return time, etc.

3. The basic requirements for the design of this topic:

A system analysis report must be submitted, including the functional analysis of the system, the functional module design of the system, the data dictionary of the database, the conceptual structure of the database (e r diagram), the structure and definition of the tables, views (if used), and stored procedures (if used) in the database (which can be provided by SQL scripts);

Program design report: including the running environment, development environment, and detailed design of the program (including the relationship between modules, the functions of modules, and the program segments implemented by the main functions).

The source code of the system, including the database script.

Take a look at this again and hope it helps.

BS courses are designed for both supply and demand. One is unlearned, the other is harmful.