Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / Experiment 8?Project Goal The goal of this project is to provide a realistic experience in the conceptual design, logical design, implementation, operation, and maintenance of a relational database and associated applications

Experiment 8?Project Goal The goal of this project is to provide a realistic experience in the conceptual design, logical design, implementation, operation, and maintenance of a relational database and associated applications

Computer Science

  1. Experiment 8?Project
    1. Goal

The goal of this project is to provide a realistic experience in the conceptual design, logical design, implementation, operation, and maintenance of a relational database and associated applications.

    1. Requirement

 

  1. Experimental steps

(1) First of all, do a simple requirement analysis for the selected experiment.

(2) Make data flow diagram and data dictionary.

(3) Design E-R diagram (conceptual structure design) based on the data flow diagram and dictionary.

(4)Based on the E-R diagram, design the relational schema (at least meet 3NF) (logical structure design).

(5) According to various data requests in requirement analysis, obtain various views and descriptions of constraints, rules and trigger scripts.

(6) According to the content of (5), design the database in mysql, or SQL server, etc.

(7) To realize the designed functions with one language you are familiar with. The design must include the query, addition, modification and deletion of data.

(8)Write a document for the previous steps, collect program source code, executable program.

(9) At the end of the experiment report, write the problems you have encountered in the experiment and the solutions.

  1. Submission of achievements:
  1. Complete experimental report (the report includes( 1)-(5 )and (9 )in the above requirements). Note that it is not necessary to paste the source code of client program into the report, but the code of database such as trigger and stored procedure can be described and written into the experiment report. In addition, please write the development environment (including language, platform, name and version of the database you used) into the experiment report.
  2. Database backup file, as well as related SQL statements.
  3. Source code and executable program.
  4. Configuration document: describes how to configure the program to run normally.
  5. Other: installation package, help documents, demo video, etc. (optional).
  1. Marking criteria:

Requirement analysis: 5 points (data flow diagram and data dictionary)

Concept design: 10 points (E-R diagram)

Logical design: 10 points (relational schema, including function dependences, primary key, etc. optimization, table design)

Physical design: 5 points (index design, etc.)

Program source code: 60 points

Others: 10 points (document, environment configuration, etc.)

    1. Experiment systems

Choose one of the following topics or choose your own topic for experiment, and write the experiment report. The functions listed in each of the following topics are for reference only. You can design the functions by yourself in the experiment.

      1. Library Management System

A simple library management system includes the information of books in the library, the information of students and the borrowing information of students. The function of the system is divided into two parts: student oriented and administrator oriented. The student oriented part contains borrow, renew, return and query books; the administrator oriented part contains complete the addition, deletion and modification of books and students, as well as the confirmation of students' borrowing, renewing and returning.

      1. Student Status Management System

Student status management system can mainly manage students' files and grades.

1. Establish student files, you can input, modify and query the student status information.

2. You can input, modify and query the student's grades and average scores.

      1. Ticket Selling Management System

Investigate the city's long-distance bus station or railway station ticket business, design the ticket selling management system. The following functions are required:

  1. It has convenient and fast ticket selling function, including ticket reservation and refund function, supporting group reservation and refund.
  2. It is convenient to query the timetable or train number, ticket price and other information.
  3. Various information stored in the system can be changed.

 

      1. Enterprise personnel management system

To understand the personnel management of the enterprise, and design enterprise personnel management system according to the specific situation. The main functions are as follows:

  1. Recruitment and employment of employees.
  2. Attendance, overtime,  business trip management.
  3. Personnel changes: new employee registration, employee resignation registration, etc.
  4. Employee training records.
  5. Employee assessment, reward and punishment records.
      1. Telephone payment management system

According to the current telecom, China Mobile, Unicom and other specific circumstances, design the telephone payment management system. The main functions are as follows:

  1. Registration and management of telephone user information.
  2. Payment of telephone charges.
  3. Modification of various telephone charges.
  4. Various inquiries about telephone charges.
  5. Various statistical functions.

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE