Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i . Create a database table Modify table - manager.php to create a new table in your database. ( 3 marks ) So far the

i.Create a database table
Modify table-manager.php to create a new table in your database.
(3 marks)
So far the code has used an existing database table called tt284_guests, but that has no provision for a booking reference field. You will now create a new table in your database.
Examine the file table-manager.php
Notice the variable $database_table which must be set to the name of your new table required. You will create a table called tt284_oucu.(Where 'oucu' is replaced with your own OUCU).
Your new table will contain all the columns which exist in tt284_guests, with the addition of the new booking reference column. Base your answer closely on the existing SQL statement.
The booking reference field may contain up to 10 characters.
Modify the SQL statement in the $create_sql variable to meet these requirements. Remember that column names cannot contain spaces, so you must choose a suitable name. Once you are happy with your SQL, open table-manager.php on the TT284 server and click the create button to execute the SQL to create the table.
Once a table is created it cannot be modified, so if you create a table with the incorrect structure, you must delete it before you can create a corrected version. This can be done using the drop button when executing table-manager.php.
In your solution document, provide your code and a screenshot of your browser displaying the result of executing table-manager.php

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

More Books

Students also viewed these Databases questions

Question

Question Can any type of stock or securities be used in an ESOP?

Answered: 1 week ago

Question

Question Can a self-employed person adopt a money purchase plan?

Answered: 1 week ago