Configuring a Database

Assignment #7: Configuring a Database There are two parts to this assignment. The first part is to create a database and some tables which will be appropriate for a home-budgeting application. That portion of the assignment should be completed from the MySQL console command line. The second part of the assignment is to write a PHP script which will display 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 the command-line interface to create a new user named “script” for your database. Grant that user all permissions on everything controlled by the DBMS.* Create a database named “homebudget”.* Within that database, create two tables:o The first table should be named “estimates”. Give it three fields:+ VARCHAR of length 10 named “category”+ VARCHAR of length 30 named “description”+ INT named “budget”o The second table should be named “expenses”. Give it three fields:+ VARCHAR of length 10 named “category”+ DATE named “expenseDate”+ INT named “expenditure”* Create a script file named solution07.php. Within that script, connect to your DBMS using the “script” identity.

Select the “homebudget” database, then obtain a listing of the tables.* Use 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.

We help you get better grades, improve your productivity and get more fun out of college!!

Homework Answers Online

Free title page

Free reference page

Free formatting

Unlimited revisions

WhatsApp chat

How it works – it’s easy

i

Place your Order

Submit your requirements through our small easy order form. Be sure to include and attach any relevant materials.

Make a payment

The total price of your order is based on number of pages, academic level and deadline.

i

Writing process

We assign the assignment to the most qualified tutor. When the tutor completes the assignment, it is transferred to one of our professional editors to ensure that the assignment meets all of your requirements.

Once complete, we’ll send your assignment via the email provided on the order form.

 

 

Achieve academic success with the best online tutors