Create a sql database, PL-SQL Programming

Assignment Help:

The requirements as follows:

Create a folder called "SECURITY" on the server and upload all your project files to that folder. Please note, the "SECURITY" folder is NOT to be INSIDE ANOTHER FOLDER. REQUIREMENTS FOR SITE

 SERVER SIDE :You have been given a blank database in phpMyAdmin called securityxx which you will need to use for this work. Services · Make the information about the Guard Services page (guards.html) database driven. · Create a table called tblServices · Add appropriate fields to hold relevant information as per the guards.html example.

  • The client would like to "spice" this page up a little by putting appropriate photo's next to each section.

 o It is your job to source the photo's.

 o The photo URL's must come from the database

Administration

  • Add a subtle login link at the bottom of the home page.
  • The login will check for correct username and password.
  • A table of administrators,called tblAdmin, must be created with usernames and passwords ONE of which MUST BE YOUR CLASS USERNAME AND PASSWORD, for example, line1,jaguar20

Administrators, who have correctly logged in, can access an admin menu that will enable them to o update/change the data in tblServices.

o Add a new service to Use javascript to check that fields have correct information

o Delete an existing service

o View the tblCheckUpload as a table with the name of the admin who changed the file and the date/time last modified o Add a new administrator

o The admin section should be secured using session management

o Logout for administrator section

  • Administrators can also exit to the home page at any time

. Check Table · Create a table called tblCheckUpload

· This table should include fields for

o Who added altered or deleted data

o Date and time info was altered .

The Mysql database structure:db name:security01

tblServices

Field                          Type     Null       Default             Comments

sr_ID                          int(11)       No                     

sr_title               varchar(50)        No                     

sr_description   varchar(50)        No                     

sr_image           varchar(50)        No                     

tblCheckUpload

Field                             Type           Null       Default             Comments

ch_checkuploadID         int(50)       No                     

ch_date                varchar(50)        No                     

ch_time                varchar(50)        No                     

ad_ID                   varchar(50)        No                     

sr_ID                    varchar(50)        No                     

tblAdmin

Field                          Type          Null       Default             Comments

ad_ID                      int(11)         No                     

ad_username           int(50)        No                     

ad_name           varchar(50)        No                     

ad_address       varchar(50)        No                     

ad_phone         varchar(50)        No                     

ad_email           varchar(50)        No                     

ad_password    varchar(50)        No


Related Discussions:- Create a sql database

Enrolment was split - sql, Enrolment was split - SQL Example shows ho...

Enrolment was split - SQL Example shows how relvars IS_CALLED and IS_ENROLLED_ON can be derived from the original ENROLMENT relvar, using projection in the initial assignment

Return statement, RETURN Statement The RETURN statement instantly compl...

RETURN Statement The RETURN statement instantly completes the execution of a subprogram and returns control to the caller. The Execution then resumes with the statement below t

Develop a job management site, Lightweight system to provide and take info ...

Lightweight system to provide and take info from workers in the field and office, have basic design outlined already just require build and implementation Desired Skills CSS,

Declaring and initializing objects in pl/sql, Declaring and Initializing Ob...

Declaring and Initializing Objects: An object type is once defined and installed in the schema; you can use it to declare the objects in any PL/SQL, subprogram, block or packa

Effects of null, Effects of NULL The numeric variable X, perhaps of ty...

Effects of NULL The numeric variable X, perhaps of type INTEGER, might be assigned NULL. In that case the result of evaluating X + 1 is NULL, and so SET Y = X + 1 assigns NULL

Truth tables , Truth Tables: However in propositional logic - here we ...

Truth Tables: However in propositional logic - here we are restricted to expressing sentences and where the propositions are true or false - so we can check where a particular

Iterative control: loop statement, Iterative Control: LOOP  Statements T...

Iterative Control: LOOP  Statements The LOOP statement executes a series of statements multiple times. There are 3 forms of LOOP statements: LOOP, WHILE-LOOP, & FOR-LOOP. LOOP

Ending transactions, Ending Transactions A good quality programming pr...

Ending Transactions A good quality programming practice is to commit or roll back every transaction explicitly. Whether you rollback or issue the commit in your PL/SQL program

Functions in pl/sql, Functions   The function is a subprogram that cal...

Functions   The function is a subprogram that calculates a value. The Functions and procedures are structured similar, except that the functions have a RETURN clause. You can

Program, heap sort program in pl/sql

heap sort program in pl/sql

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd