Natalie wants to create a database to collect information about sales transactions. she would like to use the database to look up customer names and sales prices if they return a product she would like to sort the items in the database by product number. what fields should she have in her database?

Customer Table

Customer name Customer id

Product Table

Product id/number (primary key, auto increment)Product nameProduct sale price

Transactions Table

Transaction IdCustomer IdProduct idQuantityPriceDate

Explanation:

Natalie wants to fetch following information from database

Look up customer name and sale priceSort items in db by product number

To lookup customer name and sale price perform a join on Transactions table and Customer table.Assuming database is build in mysql the query to fetch required results would be

select transction.productId,transaction.customerid,customer.customername from transactions join customer ON

customer.customerid=transcation.customerid

where productid="user provided product id of returned product"

For sorting products by number set produc number in product table a auto increment primary key

Solution: the categorization of functional and non-functional requirement are as follows: some of the more typical functional requirements include: • business rules• transaction corrections, adjustments and cancellations• administrative functions• authentication• authorization levels• audit tracking• external interfaces• certification requirements• reporting requirements• historical data• legal or regulatory requirementswhile,some typical non-functional requirements are: • performance – for example response time, throughput, utilization, static volumetric• scalability• capacity• availability• reliability• recoverability• maintainability• serviceability• security• regulatory• manageability• environmental• data integrity• usability• interoperability