(1) understand the basic content of the database design,
(2) to master the whole process of database design,
(3) learn to write the conceptual design specifications, logic design specifications,
2. The experiment content
Book sales management of the database design
Demand analysis
Problem description:
A bookstore area of nearly 100 square meters, all kinds of books, thousands of number nearly half copies, all books classify put, in order to improve the economic benefits of bookstores, book adopted a variety of marketing strategies, such as: not on a regular basis to carry out promotional activities, carried out on the part of the book at a discount; Adopt open mode, for customers to choose books; Read for customers to establish membership card, execute privilege points, such as for books related data, sales information, inventory information, customer information management in the form of using artificial often appear: the leadership and customers is difficult to satisfy the requirement, if not timely provide the specified book inventory information, sales, etc., affect the image of a bookstore and benefits, therefore, hope to use the computer, to realize the management of book sales, real time for the customer, leadership, bookstore staff to provide accurate data, the workload of the bookstore staff, improve work efficiency, to provide customers with better service, promote the service quality and service level of the bookstore,
It is understood that the bookstore business needs is as follows:
Book retail purchase: customer acquisition after proceed to checkout, the cashier for member can provide the corresponding discount bookstore, input the number of books and need to buy to calculate the total amount, in cash or card selected by the user to check, and provide the sales receipts serial number as sales documents, for members, also calculates the corresponding points,
Book retail returns: customers have bought the book for return, you need to provide books and the sales receipts to serve as proof of purchase, query the database system for data validation, to return, conform to the requirements of the book
Book catalog: bookstore from the press after buying new books, according to stock listing catalog, only after cataloging of books can be for sale,
For: can use ISBN, title, press has three ways to find the cataloguing books,
Of the library of books and materials change: for the catalog to modify the basic information of the book, the retail price and the lowest discount,
Book purchase: for the cataloging of books to replenish onr's stock, at the same time dealing with the amount difference,
Book return: for the cataloging of books return, handle the amount difference at the same time,
Press management: add, delete, modify the press, publishing house of information at the same time,
Members add: add new members, at the same time, the basic information of the registered members, the period of validity, specify the group members, etc.,
Member lookup: provide membership number, id number, member names and complex queries,
Member delete: delete the existing members,
Member information modification: the basic data of members, modified
System Settings: to add, delete, modify the system operators, at the same time to the corresponding operator set its control permissions,
Password change: to modify the current system operator's password,
Data management: to provide the system database backup and restore,
Report processing: provide sales order, receipt, membership list, press list, sales orders, and so on statements,
1. According to the result of demand survey, list the system data dictionary:
(1) data class
C1: books
C2: the bookstore staff (buyer, catalogers, salesman, the cashier)
C3: member
C4: press
C5: stock
C6: sales
...
(2) data item
According to the demand of the system, to list the items of each data class
Table 1 item table
Number of data items corresponding class data type, data length note
I1 ISBN C1 character, variable length 20 books, not empty
... ... ... ... ...
3. Semantic constraints
(1) the bookshop with several department, it includes the purchase department, sales department, cashier department, service department,
(2) the bookstore several worker, each of them work in a department, each department has a number of people,
(3) for each worker is responsible for their own work, center the purpose is to book sales,
(4) the sales of books can come from different press; Have the same title,
(5) all books must be catalog first, after sales; Every book has several, and purchase price, carried out, the sale price, sales; Stock time is different, the purchase price may be different; All kinds of books in different time periods may have different discount,
(6) customers are free to decide whether to become a member; Different members may have different discount, discount rate and the customer in the store's total consumption;
(7) every sales must have a unique serial number;
(8) personnel gender either male or female,
(9) the bookstore staff aged 18 to 60; The age of the customer of the nonnegative integers smaller than 120,
CodePudding user response:
Who is going to be ok for you to get this, is really carefree egg hurts, this BBS is asking the questions, not for you to do your homework, the younger brother
CodePudding user response:
How are you this design report to you? I want to draw lessons from the place where there are many don't understand, thank you