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

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 )

#1: How and where can you use foreign keys in these relations?Create / alter the relations so that they implement foreignkeys.

A: Identify modifications to sample data that works with theforeign keys you have created.

B: Identify modifications to sampledata that violates the foreign keys you have created. How wouldthese foreign key constraint violations handled by MariaDB?

Expert Answer

---

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