View the step-by-step solution to:

Assignment 4: Database Application Development The Northwind database created by Microsoft contains the sales data for a ctitious company called...

Can you please help me with the assignment?

ThanksImage 1.pngImage 2.pngImage 3.png

Image 1.png

Assignment 4: Database Application Development The Northwind database created by Microsoft contains the sales data for a fictitious company called
Northwind Traders, which imports and exports specialty foods from around the world. Here is the
schema of the database: Products fProductiD, ProductNome, Supplierlfl, Cotegoryil}, fluontityPerUnit. UnitPrI'ce,
UnitsinStock, Unitsflnfirden Reorderteuei, Discontinued]; Suppliers f5uppiierlfl, Componyflome, Contoc‘tNorne, Contoct‘l'itie, Address, City, Region,
PostoiCode, Country, Phone, Fax, HomePoge}; Categories fCoteyoryiD, CotegoryNome, Description, Picture}; Orders [Orderiil Customerlfl, EmployeeiD, OrderDote, Requiredflote, Shippedflote, Shipli’io,
Freight, ShipNome, ShipAddress. ShipCI'ty, Shipfleyioo, ShipPosthiCode, ShipCountry}; OrdeLdetoiis fill}, 0rderiD, Productlfl, UnitPrioe, Quantity; Discount}; Customers fflistornerifl, ComponyNome, Contocm‘ome, Contoct'l'itle, Address, City,
Region PostoiCode, County, Phone, For}; Empioyees fErnpioyeeiD, Lostflome, FirstNome, Title, TrtieflfCourtesg Birthflote, HireDote,
Address, City, Region, PostoiCode, Country, HomePhone, Extension, Photo, Notes, ReportsTo}; Shippers (Shipperifl, Componyh‘ome, Phone}; Run SQL script norfl1wind.sql to create the above schema and load sample data in MySQL. This assignment lets you exercise on database application development using a programming language
of your choice [[2, Java, or PHPJ. Write an interactive text—based program. It repeatedly gives the user a
menu of options to choose from, then carry out their request, until heishe finally choose the exit option. Your program should take care of all SQL queries “nth proper errorfexception handling. Your program
should also have proper transaction support. Your program should interact using plain text only. To make compiling and grading easier, do not
include graphics or any other fancyr interfaoe. Your too menu land the tasks you are asked to imolementl includes the followi no:

Image 2.png

Yo ur top menu {and the tasks 1you are asked to im plement} includes the following: add a customer add an order remove an order ship an order print pending orders with customer information
restock parts exit rJP‘P‘PE-"Pl‘ Yo u'll receive 10 points for oorrect im plementalj on of each of the above items 1-6. Keep in mind Ihe
following 1when you write your code: up User will be promoted to enter the necessary info, one field at a name.
i All “)5 except CustomerlD are automatically generated. {eg the biggest existing number + 1'_L
. Most attribute values are required [NOT NU LL]. . When add an order:
I: Add to both ORDERS and DHBER_DETAILS.
o Pay attention to the foreign key constraints on CustomerID, EmployeelD, Ship'v'ia,

Image 3.png

c When add an order:
a Add to both ORDERS and DRUER_DETAILS.
0 Pay attention to the foreign key constraint. on {.‘ustornerlD, EmployeelD, Ship'h'ia,
Froductlfl, OrderID.
an Update the Products's UnitsCanrder.
o The order should be rejected if a product in the order is disoounted.
o When remove an order:
a Delete the entry in both the ORDER and the DRDEILDETAILS tables.
0 Update the UnilsDnDrder attribute.
o When printing pending order list:
0 Print only pending orders [i.e. orders with NULL ShippedDatei.
0 Print them in the order of order date.
o Your node is expected to provide support of database transactions in proper ways.
i Appropriate error—checking and error-handling is expected.
o A user might enter a new record whose key already exists in the table. Handle this
appropriately.
o Always assume the way it works in real worl d, if the above rules are not sufficient or not clear.
o If you have implemented extra features, document the features clearly in the README file. For information on how to use MySQL connectors, please refer to
h : demo] icon] d re on 5.5 e connectors-o "shtmi. Put your source code and a README file [describing how to oompile your code, extra features you have
implemented, and other stuffyou want us to know} into a zip file and submit to e—leaming.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question