Create a sql database, PL-SQL Programming

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


  • 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


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                     


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                     


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

Posted Date: 3/15/2013 2:52:06 AM | Location : United States

Related Discussions:- Create a sql database, Assignment Help, Ask Question on Create a sql database, Get Answer, Expert's Help, Create a sql database Discussions

Write discussion on Create a sql database
Your posts are moderated
Related Questions
Pl/SQL Expressions The Expressions are constructed by using the operands and operators. An operand is a constant, literal, variable, or function call which contributes a value

Albeit simple method : These all the truth tables give us our first as albeit simple method for proving a theorem: where check whether it can be written in propositional logic

Map and Order Methods: The values of the scalar datatype like CHAR or REAL have a predefined order that allows them to be compared. While, the instances of an object type has

Deleting Objects You can use the DELETE statement to eradicate objects from an object table. To eradicate objects selectively, you use the WHERE clause, as shown below: BEG

Task 2 [12 marks] Write the package body for the following package specification (the detailed description of each function and procedure is provided in the appendix below). Place

Use Bulk Binds If SQL statements execute inside a loop using the collection elements as bind variables, context switching between the PL/SQL & SQL engines can slow down the ex

IN Mode An IN parameter pass the values to the subprogram being called. Within the subprogram, an IN parameter acts like a constant. And hence, it cannot be assigned a value.

Using FORALL and BULK COLLECT Together You can unite the BULK COLLECT clause with the FORALL statement, in that case, the SQL engine bulk-binds column values incrementally. In

Introduction Oracle 9i - it was made public in the year 2001 with over 400 features, and graphics, it has merged the traditional business with modern internet application

Initial thought process: Design a script which was simple and user friendly. Integrate procedures/functions to extract data under the hood. I focused on giving the user the opt