Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I have an assign which is about creating content for each table, It is like creating a database for a renting bike company. I have

I have an assign which is about creating content for each table, It is like creating a database for a renting bike company. I have attributes for each table. But need the exactly content in these attributes. It is an assign related to computer science and accounting major. So, i hope someone can help me with that. I will attach an ERD below. It is like a script for me to further create SQL server. I will wait online if someone can help me just let me know i will reply ASAP. Thank you

image text in transcribed Gridhub is a name of company in phoenix. They rent bikes. What I need looks like /* CREATE TABLES FOR SPORT SHOP ONE TABLE AT A TIME /* */ CREATE, INSERT, AND DISPLAY THE CONTENTS OF THE PRODUCTS TABLE */ create table PRODUCTS (ProdID integer Not null, Descrip varchar(50) Not null, Price decimal(4,2), Primary key(ProdID)); insert insert insert insert insert insert insert insert insert insert into into into into into into into into into into PRODUCTS PRODUCTS PRODUCTS PRODUCTS PRODUCTS PRODUCTS PRODUCTS PRODUCTS PRODUCTS PRODUCTS values values values values values values values values values values Select * from PRODUCTS; It is used for further SQL server. (100860,'ace tennis racket I',65.00); (100861,'ace tennis racket II',58.00); (100870,'ace tennis balls-3 pack',15.80); (100871,'ace tennis balls-6 pack',10.00); (100890,'ace tennis net',74.00); (101860,'sp tennis racket',37.00); (101863,'sp junior racket',25.00); (102130,'rh: "guide to tennis"',8.95); (200376,'sb energy bar-6 pack',7.00); (200380,'sb vita snack-6 pack',8.40)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial And Management Accounting An Introduction

Authors: Pauline Weetman

8th Edition

1292244410, 978-1292244419

More Books

Students also viewed these Accounting questions

Question

1. To generate a discussion on the concept of roles

Answered: 1 week ago

Question

6. What information processes operate in communication situations?

Answered: 1 week ago

Question

3. How can we use information and communication to generate trust?

Answered: 1 week ago