DEPARTMENT OF MANAGEMENT (LSM) TERM PAPER OF DATABASE MANAGEMENT SYSYTEM (DBMS) 0N FINANCIAL ACCOUNTING SYSTEM FOR A MEDIUM SIZE ORGANISZATION SUBMITTED TO : MR. NANDAN SUBMITTED BY : SHUJA QAMME...
Thsi project is from back end databse programming how triggers are created and how procedures are written in pl/sql
AN APPROACH TO ACCESS THE REMOTE DATABASE FROM MOBILE CLIENTS
dbmsFull description
dbms
DBMS pointsDeskripsi lengkap
Full description
Notes for database management system
Here you can find 1000's of Multiple Choice Questions(MCQs) of Database Management System(DBMS) includes the MCQs of fundamental of Database Management System(DBMS), introduction of Database Model,...
Full description
Full description
dbmsFull description
SQL Project Internet Book Shop
BACKGROUND
This project requires you to develop a database to support a company whose customers like to browse and purchase books over the Internet. This project requires you to develop a prototype to demonstrate the capabilities and design of a database. It is not required that you create a web‐based database at this time; however you must be able to show the functionality and performance of such a database. PART I Requirements
Customers should be able to browse a catalog of books and place orders. Most corporate customers provide a ISBN number and a quantity; they often pay by credit card. The books are prepared for shipment if they are in stock. If there aren’t enough copies in stock, additional copies are ordered and the order is delayed until all books are ready for shipment. The catalog includes all the books that are available for sale. The each book, the catalog contains its ISBN number, title, author, purchase price, sales price, and the year the book was published. Most of the customers are regulars and should their names and addresses should be in the database. New customers must be entered into the database so that an account can be established, before they can order a book. On the website, the customers should be able to enter a userid and login password before they can order a book. Some additional information: If a customer places two orders for the same book in one day, the first order is handled by creating a new Orders relationship and the second order is handled by updating the value of the quantity attribute in this relationship. If a customer places two orders for different books in one day, each instance of the Orders relationship set relates the customer to a different book. TASKS
1. Develop an ER diagram to that captures the entities, their attributes, and the relations. 2. Develop the relational model that from the ER diagram.
PART II Additional requirements:
1. It must be possible to order several different books in a single order. 2. The customer must be able to distinguish between several orders placed the same day. 3. Employees should be able to see customer order information with seeing customer sensitive credit card data. Tasks:
1. Complete the logical DB Design 2. Update the ER diagram and create the relational tables that with the appropriate constraints 3. Implement the database and create any views that are necessary
PART III
Develop the queries and user interface that supports the following requirements: 1. Customers search books by author name, title, or ISBN 2. Employees register new customers and edit existing customer data. 3. Customers check out a final shopping basket to complete a sale. 4. Customers add and delete books from a ‘shopping basket’ 5. Customers check the status of an existing order and look at old orders 6. Employees look up customer contact information 7. Employees add new books to the inventory 8. Employees fulfill orders, and need to update the shipping date 9. Employees analyze the data to find profitable customers and customers likely to respond to special marketing campaigns.