[Solved]Given Relations Accounts Aid Integer Balance Double Type String Type Must One Credit Check Q37291756

Given these relations:

Accounts( aid: integer, balance: double, type: String ) [

type must be one of credit, checking, or cash ]

Customers( name: String, address: String, aid: integer )

Employees( eid: integer, name: String, position: String, salary:double )

Employs( store: String, eid: integer )

Inventory( name: String, item: String, quantity: integer )

Items( item: String, brand: String, price: double )

Stores( name: String, location: String )

Transactions( tid: integer, store: String, item: String,customer: String, date: Date )

4)

A) Create a function that determines the nth most profitablestore. Receive the value n as a parameter.

B) Using your solution to (A), create a view that represents thestores in order of their profitability. Include the store name andprofits as attributes in the view.

Expert Answer

---

Answer to Given these relations: Accounts( aid: integer, balance: double, type: String ) [ type must be one of credit, checking, o… . . .