logo

(Solved) Assignment on Database System

   

Added on  2021-06-17

11 Pages618 Words169 Views
Running head: DATABASE SYSTEMDatabase SystemName of the Student:Name of the University:Author Note

1DATABASE SYSTEMLogical Database DesignChoosing an applicationFor the assignment the chosen application used for description is that of Online GameShop. This is an online shop in which the gamers can register their details and buys the latestgames from the online store. The name of the games and the developers would be stored in thedatabase and also there would be staffs that would be processing the purchase of the gamers andthe names and the details of the staffs would also be stored in the system.Queries1.List of all the game developers registered in the system.2.List of all the orders made on 28 April 20153.List of names of the Gamers starting with A.4.List of the games available at the online store.5.List of all orders for a particular gamer.6.List of all orders under a particular staff7.List of all games Created by “Ubisoft”8.What is Address of Sammy9.Name of the developer of the game “FIFA 2018”10.Which is the Game with the highest price?AssumptionsThe only assumption made during the designing of the database is that the staffs wouldbe accessing the systems manually hence, the data of the staffs would be stored in the system and

2DATABASE SYSTEMthe data that is provided by the system by the gamers would be automated and the data enteredby the staffs would be handled by the system manually.ER DiagramRelational Database SchemaDeveloper (developerID (pk), Name)Game (GameID (pk), developerID (fk), GameName, Price)Gamers (GamerID(pk), GamerName, GamerAddress, Contact)Orders (OrderID (pk), GameID (fk), GamerID (fk), OrderDate)Invoice (InvoiceID (pk), OrderID (fk), StaffID (fk), GamerID (fk))Staff (StaffID (pk), Name, sContact, Salary)Functional dependenciesdeveloperID NameGamerIDGamerName, GamerAddress, ContactOrderIDproductID, customerID, OrderDateproductIDbrandID, pName, Price

3DATABASE SYSTEMInvoiceIDOrderID, StaffID, CustomerIDStaffIDName, sContact, SalaryDecompositionThe database is already decomposed to its highest from and can-not be decomposed anyfurther.Relational algebra1 π (developer)2 π (σ OrderDate (Order) = 28 April 2015)3 π GamerName (σ GamerName (Gamers) = LIKE ‘%a’)4 π (game)5 π (σ GamerID (Order) = n)6 π (σ StaffID (Invoice) = n)7 π (σ DeveloperID (Game) = ‘’)8 π Address (σ Name (Customer) = James)9 π Contact (σ Name (Staffs) = James)10 π(σ Price (Product) = maximum)Unanswerable queries1.The name of the staff who sells the gamers that re developed by “EA Sports”2.The name of the Gamer who bought products of “EA Sports”

End of preview

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

Related Documents
Database Systems - Solved Assignment
|13
|512
|53

Relational Database and its Working
|15
|882
|186

Database System and Design
|12
|900
|278