Create a database for a home-budgeting application

Assignment Help Database Management System

Reference no: EM1360237

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.

Reference no: EM1360237

Questions Cloud

Accounting principles : Juan's Taco Corporation has restauraunts in five college towns. Juan wants to expand into Austin and College Station and needs a bank loan to do this. Mr. Bryan, the banker,.

Counterproductive work behavior - tools to mitigate : From the e-Activity, determine the five guidelines listed and provide an example of an appropriate tool that might help achieve each guideline.

Find the maximum altitude reached by the rocket : Find the maximum altitude reached by the rocket.Find its total time of flight.

Difference in income between men and women : Determine whether there is a significant difference in income between men and women. what statistical test would you use?

Create a database for a home-budgeting application : 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.

Compute cost of preferred stock : Hettenhouse Corporation's perpetual preferred stock sells for $102.50 per share, and it pays a $9.50 annual dividend. If the corporation were to sell a new preferred issue,

What is the magnitude of the charge on each sphere : what is the magnitude of the charge on each sphere. A car crashes into a wall at 45 m/s and is brought to rest in 0.1 s. compute the average force exerted on a 80 kg test dummy by the seat belt.

Learning technique for african american families : Do you think learning by modeling after their parents, grandparents, etc. is a common type of learning technique for African American families?

Explain what this all inclusive web site on all labor laws : Explain what this all inclusive web site on all labor laws and procedures contains and then select one subject or area of information that you learned from this great web site

User Account

All Pages