OC how to achieve with book sales system,

Create a book sales system:
1, a book has a name, number, price and release date. Seller has the name, number, sales list (he was responsible for sales of the book contains a number), total sales, sales history.
2, the system can be arbitrarily assigned to a book, a salesperson
3, the salesman can sell his list of a book, the book of Numbers removed from his list, while total sales increased (increasing the amount of the price of the book), to be recorded in the history books prices and sales time.
4, the system can be set to "banned" words to match disabled by specifying whether to include the title, the book is no longer if you include the sale of all books sold need to recover (corresponding reduction in total sales salesman)
5, for all salespeople
sorted according to total sales6 to identify the worst salesman sales of all unsold books.

Printing Requirements:
1, print a book all the information and all the information a salesperson.
2, to achieve a specified book salesman approach
3, print all the information a salesperson sold a book after
4, disable printing of a book salesman after all the information
5, total sales sorted by printing the names of all salespeople
6, print the name of unsold books salesperson information.
Reply:
This is a project you want to outsource it?
Reply:
Outsourcing is not able to print out OK, payment can be able to achieve
Reply:
I can say I have no idea what you ask it?
Reply:
with OC language compiled code, so the code can achieve more function examination questions today, I did the first three, not behind the
Reply:
The first thing you need to do is to analyze and database design
According to the relationship you describe, there should be the following table:

book table (the book name, number, price and date of issue, whether to ban the sale of flags)
saler table (sales person name, number)
bookofsaler Table (book salesman and the associated table, the salesman and book-to-many relationship - book ID, salesperson ID, time)
sell table (sales record sheet - Seller ID, book ID, sold price, sale time)

1, print a book all the information and all the information a salesperson.
Print table to retrieve a book from the book, information retrieval
salesman from saler table2, to achieve a specified book salesman approach
Insert salesperson ID and specify the ID to bookofsaler table book
3, print all the information a salesperson sold a book after
To sell the main table table table associated with book and saler table retrieval
4, disable printing of a book salesman after all the information
Table associated with saler table-based query sell sheets and book tables get
5, total sales sorted by printing the names of all salespeople
Summary sell table and sort get sold prices salesperson ID, associated saler table then query
6, print the name of unsold books salesperson information.
Main table associated with bookofsaler table book table and saler table retrieval


For complex data structures, storage can be used in ios have sqlite, coredata


Reply:

references, 5th Floor zhanglei5415 reply:

first thing you do is analysis and database design
According to the relationship you describe, there should be the following table:

book table (the book name, number, price and date of issue, whether to ban the sale of flags)
saler table (sales person name, number)
bookofsaler Table (book salesman and the associated table, the salesman and book-to-many relationship - book ID, salesperson ID, time)
sell table (sales record sheet - Seller ID, book ID, sold price, sale time)

1, print a book all the information and all the information a salesperson.
Print table to retrieve a book from the book, information retrieval
salesman from saler table2, to achieve a specified book salesman approach
Insert salesperson ID and specify the ID to bookofsaler table book
3, print all the information a salesperson sold a book after
To sell the main table table table associated with book and saler table retrieval
4, disable printing of a book salesman after all the information
Table associated with saler table-based query sell sheets and book tables get
5, total sales sorted by printing the names of all salespeople
Summary sell table and sort get sold prices salesperson ID, associated saler table then query
6, print the name of unsold books salesperson information.
Main table associated with bookofsaler table book table and saler table retrieval


For complex data structures, storage can be used in ios have sqlite, coredata

Thank you anyway, I made yesterday came out, woman ape is slow to respond when the program a beat.