logo

Database Systems - Solved Assignment

   

Added on  2021-05-31

13 Pages512 Words53 Views
Running head: DATABASE SYSTEMDatabase SystemName of the Student:Name of the University:Author Note
Database Systems - Solved Assignment_1
1DATABASE SYSTEMLogical Database DesignChoosing an applicationThe application that is being chosen here is that of an online mobile store. The databasewould store the details of the products available in the system and details of the product purchaseand customers as well.Queries1.List of all the brand available in the shop2.List of all the orders made on 16 May 20183.List of names of the customer starting with a.4.List of the products in the shop5.List of all orders for a particular customer6.List of all orders under a particular staff7.List of all products under the brand “Nokia”.8.What is Address of James9.Contact of James10.Which is the product with the highest price?AssumptionsIt is assumed that the store is online however the staffs of the system can access theonline system and handle the invoices.
Database Systems - Solved Assignment_2
2DATABASE SYSTEMER DiagramRelational Database SchemaBrand (brandID (pk), Name)Product (prpductID (pk), brandID (fk), pName, Price)Customer (CustomerID (pk), cName, cAddress, Contact)Orders (OrderID (pk), productID (fk), customerID (fk), OrderDate)Invoice (InvoiceID (pk), OrderID (fk), StaffID (fk), CustomerID (fk))Staff (StaffID (pk), Name, sContact, Salary)Functional dependenciesbrandID NameCustomerIDcName, cAddress, ContactOrderIDproductID, customerID, OrderDate
Database Systems - Solved Assignment_3
3DATABASE SYSTEMproductIDbrandID, pName, PriceInvoiceIDOrderID, StaffID, CustomerIDStaffIDName, sContact, SalaryDecompositionThe database is already decomposed to the to its highest from and can-not bedecomposed any further.Relational algebra1 π (brand)2 π (σ OrderDate (Order) = 16 May 2018)3 π cName (σ cName (Customer) = LIKE ‘%a’)4 π (product)5 π (σ CustomerID (Order) = n)6 π (σ StaffID (Invoice) = n)7 π (σ BrandName (prodcut) = Nokia)8 π Address (σ Name (Customer) = James)9 π Contact (σ Name (Staffs) = James)10 π(σ Price (Product) = maximum)Unanswerable queries1.The name of the staff who sells the brank NOKIA2.The name of the person who purchased the brand APPLE
Database Systems - Solved Assignment_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
(Solved) Assignment on Database System
|11
|618
|169