SQL statement Generation writing, DATA MANAGEMENT systems generation

SQL statement Generation writing, DATA MANAGEMENT systems generation
DATA MANAGEMENT SYSTEMS DESIGN PROJECT
Purpose of this project
Analyze, design, implement, and document a database system application. You'll use the
Methodology for database development learned in class. The system must is implemented on
A DBMS with any language as a host-language for the application. The system must be Menudriven
and include the basic functionality described below.
The Online computer Store
The following specifications is intended as a guide; They is not the complete specifications.
These is intended to is a basis for you to get started in the right direction in designing your
System. You as the designer must analyze and decide "what other details" or features should be
specified for your system. Thus, individual group implementations would differ in terms of design
and implementation styles. Every group have to mention clearly
Specifications is assumed. However: (a) they should not contradict the assumptions described
Below, and (b) they has the to is clearly stated in your report.
DATABASE REQUIREMENTS
(Specifications for the design of the database)
Newark-it is a company, sells computers all over the world. It's a web-based company. All
Sales is managed via a website. The company wants to build a database system for customers,
Products, and sales transactions. You are been approached to help newark-it with the
Database design and application development.
1. A customer has an ID, a first name and a surname.
2. Each customer have a home address, a telephone number, and an email address.
3. A customer can has one or many credit cards. Each credit card has a number, a security
Number, the name of its owner, the billing address, the type of credit card, and an expiry date.
4. A customer can specify multiple shipping addresses. A shipping address is identified by the
Name the customer choses for this address (which is a unique among the shipping addresses of
This customer) and the ID of the customer. For a shipping address the ZIP code, street name,
Street number, city, state and country is provided. If a customer is deleted, we need not keep
Track of hers shipping addresses any longer.
5. Customers has a status (regular, silver, gold and platinum). A status level corresponds to
Different advantages. In particular, a credits line was offered to the customers of the silver status and
Above. In addition, the company proposes each month special offers (reduced prices) for some
Products exclusively for gold and platinum status customers.
6. An offer was the combination of a particular product and a price.
7. Each product has a unique product type.
8. Each product have its own product ID, a name, a recommended price, and a brief textual
Description.
9. A customer can collect several products with a shopping basket each at a different quantity. If
The product is on offer and the customer is a gold or platinum status, she is charged the
Reduced price for this product.
Ten. A shopping basket are always non-empty. It is created with the first item added.
A successful sales transaction is recorded in the database when a customer buys a shopping
Basket, choses one and only one's shipping addresses and the payment is
Confirmed. The price and the quantity of every product in the transaction should is available as
well as the total amount of the transaction.
The payment of a sales transaction is do with a credit card. It can be one of the credits
Cards stored by the customer, or a credit card whose information are stored for this particular
Transaction.
As soon as a sales transaction is confirmed, the shipment is started. If a product is not
Delivered successfully, for instance because the cargo got lost, the transaction gets tagged with
not-delivered tag.
There is three main categories of product Types:desktop computers, laptops, and
Printers.
There is also product types that does not belong to any of these main categories (e.g.,
Different kinds of accessories).
Product types of main categories have specific attributes:desktop computers and laptops
The both a CPU type, and laptops have also a weight and a battery running time. Printers has
A resolutions and a printer-type.
Functional REQUIREMENTS
(Specifications for the development of the application programs)
The newark-it is interested in a online application program interface
That they does not has to spend time unnecessarily to train their employees. Newark-it would
Also like the program interface to be easy for the customers. In particular newark-it is
Interested in the next three Applications:customer registration and management, Online sales,
and Collection of statistics. The last application was crucial in decision making by the analysts,
Managers and knowledge workers of the company. For instance, it'll allow the introduction of
New products in certain categories or the discontinuation of certain products, or the suggestion
of new offers to increase the profit of the company. As Database and application program
Designers you is expected to write a menu-based main program which consists of the
Following three application programs for the Daily transactions of the company and are open to
The inclusion of additional functionality in the future. Note that many functions is left out in
order to reduce the size and the complexity of the project.
1. Registration and Management
Every customer have to register before being able to place an order. This interface'll help the
Customers register and manage/edit their registration information.
2. Online Sale
The online sale program would manage the shopping basket, and help the customer place an
Order. When a order is placed, the customer should being able to check and inquiry about the
Status of his/her order. The status of an order was updated as the company processes it. The
Customer should is able to view his transaction history, and pulling up specific transactions based
on different criteria (for instance, based on the name of the customer and the name of a
Product involved in the transaction).
3. Sale Statistics
This program provides statistics and are used by newark-it to analyze their sales and customers. Inch
particular, this program should is able to make the following computations:
1. For a given time period (begin date and end date) compute the most frequently sold
Products.
2. For a given time period (begin date and end date) compute the products which is sold to
The highest number of distinct customers.
3. For a given time period (begin date and end date) compute the ten best customers (in terms
of money spent) in descending order.
4. For a given time period (begin date and end date) compute the 5 best zip codes (in terms of
Shipments made).
5. For a given time period (begin date and end date) compute the average selling product price
Per product type for desktops, laptops and printers.
Deliverable 3 Requirements
Phase 3 deliverable must contain the goal of this Phase of the project, and a description of the
Creation of the database schema and instance and of the application programs. It must also
Provide any revisions made to the specifications described in Phase 2 deliverable. It must
Further describe the problems encountered in Phase 3 and justify the solutions.
? The program must run
? Make sure for ample sample data in your tables so, can sufficiently perform
and illustrate all required tasks.
? You don't have the to design a fancy interface.
1. Run SQL commands for creating tables including primary keys, secondary keys and foreign
Keys. Run SQL command files that populate each table. Each table was required to a
Sufficient number of tuples. Keep in mind the relationships between tables, and plan your data
accordingly. You should is able to run these command files successfully with no errors and no
Integrity violations.
2. You is to develop a menu driven application system for the Newark-it database as
Described in the functional requirements.
What is expected:
1. Description of implementation, problems faced.
2. Users Guide (less than 3 pages)
3. The SQL commands that create your tables
4. The SQL commands that populate your tables
5. The source code.
6. A printout of the The program.
If you miss a task mention which one. In the If you had implemented a task with a similar
Functionality it helps (mention it).
You should demonstrate your project. The demonstration have to is done by the dates provided on
The Web page of the class. You'll have the to reserve a time slots for your demo.
Cid
Http://www.6daixie.com/contents/15/1336.html

Our Direction field: Window Programming numerical algorithm AI Artificial Intelligence financial statistical Metrology analysis Big Data network programming Web programming Communication Programming game Programming Multimedia Linux plug-in programming API image processing embedded/Microcontroller database programming console process and thread Network security assembly language Hardware programming software Design Engineering Standard Rules. The generation of programming languages or tools including, but not limited to, the following ranges:

C/c++/c# Write

Java Write generation

It generation

Python writes

Tutoring Programming Jobs

The MATLAB Generation writes

Haskell writes

Processing Write

Linux Environment Setup

Rust Generation Write

Data Structure assginment Data structure generation

MIPS Generation Writing

Machine Learning Job Writing

Oracle/sql/postgresql/pig database Generation/Generation/Coaching

Web development, Web development, Web site jobs

Asp. NET Web site development

Finance insurace Statistics Statistics, regression, iteration

Prolog write

Computer Computational Method Generation

Because of professional, so trustworthy. If necessary, please add qq:99515681 or e-mail:[email protected]

: Codinghelp

SQL statement Generation writing, DATA MANAGEMENT systems generation