Business Information Systems Solved Assignment

Department of Computing
Computer Science Practice
Date of Submission: 10/08/2018
Degree Program: Business Information Systems

1 | P a g e
TABLE OF CONTENT
Page
1. Identification of Entities and Primary and Foreign Keys 2
2. Entity Relationship Diagrams 3
3. Codes 4
• Products
• Sets
• Customer
• Orders
• Payment
• Salesman
• order_sets
• salesman_sets
• products_sets
4. Queries 13

2 | P a g e
Identification of Entities and Primary Keys and Foreign Keys
Entity Attributes Primary Key Foreign Key Rationale for PK
Products productName
productId
productDescription
productDescription
productId productId can
be used to
identify the
product
Sets setName
setId
setNoOfProducts
setType
setId setId is a unique
identifier for
products.
Customer customerName
customerId
customerAddress
customerTelephone
customerId customerId can
be used to
identify the
customer
orders orderDate
orderId
orderDescription
customerId
orderId customerId orderId is used
to identify
orders.
payment paymentId
paymentMethod
paymentDate
paymentAmount
paymentId PaymentId is
used to identify
payments of
different
customers
uniquely
salesman salesmanName
salesmanId
salesmanTelephone
salesmanCommision
salesmanSalary
salesmanId salesmanId can
be used to
identify each
salesman.
order_sets idOrdering
idSet
(idOrdering,idSet) orderId
setId
idOrdering is
used to identify
the order.
setId is used to
identify the
products.
salesman_sets idsalesman
idSet
(idsalesman,idSet) salesmanId
setId
idSalesman is
used to identify
the salesman.
idSet isuse to
identify the the

3 | P a g e
products.
products_sets idProducts (idProducts ,idSet) productsId idProduct is
idSet setId used to identify
the product.
setId is used to
identify the
products.
Entity Relationship Diagrams
Logical ER Diagram