Questionconfiguring a databasethere are two parts to this

Assignment Help Computer Engineering

Reference no: EM13349496

Question

Configuring a Database

There are two parts to this work. The first part is to generate a database and some tables which will be appropriate for Batty League Flea Market. That portion of the assignment has to be completed from MySQL console command line. The second part of the assignment is to write down a PHP script which will show information about the database tables created in the first part and save that information in a file. A complete submission will include both the script - solution07.php - and the text file generated by the script - solution07.txt.

Use command-line interface to create a new user named "script" for your database. Grant that user all permissions on everything controlled by DBMS.

Create a database named "fleamarket".

Within that database, create two tables:

The first table should be named "items". Give it three fields:

VARCHAR of length 10 named "itemID"
FLOAT named "itemPrice"
VARCHAR of length 30 named "description"
The second table should be named "sales". Give it five fields:
VARCHAR of length 10 named "itemID"
FLOAT named "itemPrice"
VARCHAR of length 10 named "firstName"
VARCHAR of length 10 named "lastName"
DATE named "purchaseDate"

generate a script file named solution07.php. Within that script, connect to your DBMS using the "script" identity. Select the "fleamarket" database, and then obtain a listing of tables.

Apply the file-creation techniques we learned in previous classes to save the results of your queries into a file named solution07.txt.

Submit both solution07.php and solution07.txt.

Reference no: EM13349496

Questions Cloud

Question 1for associations to develop a capable purchasing : question 1for associations to develop a capable purchasing strategy it requires time patience and strength of mind to

Questiondesign a tips class that calculates the gratuity on : questiondesign a tips class that calculates the gratuity on a restaurant meal. its only class member variable taxrate

Questiongiven a series of numbers that represent adding : questiongiven a series of numbers that represent adding fuel 2 and subtracting fuel 1 determine highest distance that

Question audit sampling in tests of control activitiesa : question audit sampling in tests of control activitiesa. define audit sampling.b. which word properly completes each of

Questionconfiguring a databasethere are two parts to this : questionconfiguring a databasethere are two parts to this work. the first part is to generate a database and some

Question you have been asked by the managerial committee of : question you have been asked by the managerial committee of a company fictional or real to freshly implement one of the

Question 1a how did psychology develop as a methodical : question 1a how did psychology develop as a methodical field?b convoluted on the following 2 schools of

Questionin programming language c array names are not : questionin programming language c array names are not assignable variables. therefore we cant copy an array directly

Question 1a briefly describe the role of each of following : question 1a briefly describe the role of each of following four main abstractions that form part of an soa-i

User Account

All Pages