Question: Create a gameshop database using the diagram below. Implement the GameShop database, include all DDL commands. (To create a new database named GameShop you use

Create a gameshop database using the diagram below.

Implement the GameShop database, include all DDL commands. (To create a new database named GameShop you use the command: CREATE DATABASE GameShop;)

Insert at least 3 real or fictional records in each table.

Create a gameshop database using the diagram below. Implement the GameShop database,

Customers Customer ID(PK) Points Balance FirstName LasName Games. Games ID (PK) Title ESRBRating Genre ReleaseDate FranchiselD(FK) Tags XGames TaglD(FK) Game ID(FK) Tags TagID(PK) TagNae Stores Location Manager (FK) Prodcuts ProdcutID(PK) Title GameID(FK) PlatformID(FK) New Price UsedPercent (Float Default 0.7) BuyBack Percent Franchises FranchiselD(PK Name Employees EmployeeID(PK) FirstName Last Name StorelD (FK) SArctive Plafformns PlateFormID(PK) Name Maker isCurrentGen Release Date Transactions TransactionID(PK) StorelD(FK) CustomerID(FK) EmpolyeelD(FK) Date TIME ProductID(FK) Quantity PaymentTotal Inventory Inventory ID(PK) StorelD(FK Quantity isNew

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

You are a Database Administrator working for a small software solutions firm. You have been assigned to help develop a beverage imports management system. High Spirits is a small importing company...

Part A. You are a Database Administrator working for a small software solutions firm. You have been assigned to help develop a beverage imports management system. High Spirits is a small importing...

Project SEE attatchment of mom and pop database In this assignment you will create the physical database from your design created in Project 2. Project 2 was a logical model of the Mom & Pop...

Mom and POP database: Project 2 Based on the business requirements provided, the ERD would include the following entities: -Customers -Videos/DVDs -Movie -Distributors -Transactions Assignment to be...

Project 3 In this assignment you will create the physical database from your design created in Project 2. Project 2 was a logical model of the Mom & Pop database. We need to transition the logical...

Project 2 was a logical model of the Mom & Pop database. Step One: CREATE THE SQL DDL FOR YOUR DATABASE For your logical database model created in Project 2 , create the SQL DDL commands that will be...

Hi-tech Net Corp. is operating in three locations in the United States. Their main office is located in New York, NY. They have two branch offices located in Chicago, IL and Sacramento, CA. You have...

Please Answer the following 1. Consider the AIRLINE relational database schema and some sample data given in APPENDIX A. The schema describes a database for airline flight information. Each flight is...

1. Consider the AIRLINE relational database schema and some sample data given in APPENDIX A. The schema describes a database for airline flight information. Each flight is identified by a...

16. The external model yields some advantages such as ______________ a. use of the database subsets to make application program development much simpler. b. use of the database subsets to make...

For the purposes of the below questions, assume that changes in working capital are negligible and that capital spending and depreciation are of the same magnitude and therefore cancel each other...

Interview the HR manager at a local company about their hiring processes. Describe how they recruit employees to apply for jobs, the steps in the selection process, and their orientation program for...

Beryls lced Tea currenty rents a bottling machine for $ 5 1 , 0 0 0 per year, including all maintenance expenses. It is considering purchasing a machine instead, and is comparing two options: a ....

8:37 * N. 80% i ... OBJECTIVES: Create relationships Create a Pivot Table from Related Tables Create a PivotChart Modify the PivotChart The major section in this chapter :ontinuation is: Data...

2. Answer the following questions on the basis of the following three sets of data for the country of North Vaudeville: LO32.4 (A) (B) (C) Price Level Real GDP Price Level Real GDP Price Level Real...

2. Which of the following will shift the aggregate demand curve to the left? LO32.2 a. The government reduces personal income taxes. b. Interest rates rise. c. The government raises corporate profit...

5. At the current price level, producers supply $375 billion of final goods and services while consumers purchase $355 billion of final goods and services. The price level is: LO32.5 a. Above...