Question: Part I (attach this as separate word document) 1. What are Flat, Hierarchical & Network database models Part II (attach this as sal file What

 Part I (attach this as separate word document) 1. What areFlat, Hierarchical & Network database models Part II (attach this as salfile What is their advantages and disadvantages? 1. List of Products whoselistprice between 15 and 20 and sort by category 2. Display the

Part I (attach this as separate word document) 1. What are Flat, Hierarchical & Network database models Part II (attach this as sal file What is their advantages and disadvantages? 1. List of Products whose listprice between 15 and 20 and sort by category 2. Display the shipping address (address, city, state, zip) of Sales Representative (Table Hint: Employees, Orders using Sub query) 3. Display list of Product Names along with 'WhenToOrder' based on following condition. If difference between TargetLevel and ReorderLevel is greater than 50 units display WhenToOrder as 'After 50 Days If difference between TargetLevel and ReorderLevel is greater than 30 units display WhenToOrder as 'After 30 Days' If difference between TargetLevel and ReorderLevel is greater than 20 units display WhenToOrder as 'After 20 Days' If difference between TargetLevel and ReorderLevel is less than 20 units display WhenToOrder as 'Order now' 4.Display Orders which has New status. (Hint: Orders and Order_status table using sub query) .Display unique categories in Products table. 6. Display customer details sorted by job title in following order Owner Purchasing Manager Accounting Manager Purchasing Representative Purchasing Assistant Accounting Assistant 7. In Orders table display Order date in place of Shipped date when shipped date is not available 8. Display Orders which took more than 2 days to get shipped. (Hint: date function) Info Tables Columns Indexes Name customers employee_privileges employees inventory transaction_types inventory transactions invoices order details order_details_status orders orders_status orders tax status privileges products purchase order_details purchase_order status purchase_orders sales_reports shippers strings supplies NORTHWIND

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!