Opening book details…
Can I read Database Integrity Constraints Overview on EtoBox?
Database Integrity Constraints Overview by Duy Dinh is a document available to read on EtoBox.
What is Database Integrity Constraints Overview about?
The document describes a database with 5 relations: Product, Supplier, Employee, Invoice, and InvoiceLine. It then lists 12 constraints that must be satisfied on the database: 1) The sell price of a product must be higher than its purchase price. 2) Products from Samsung must be electronics (television, mobile, tablet). 3) Suppliers of mobiles/tablets cannot also supply food. 4) No product can appear more than once on an invoice. 5) Quantities in an invoice must be greater than 0. 6) Invoices must contai
- Author
- Duy Dinh
- Language
- EN