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

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

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
Magento change address format depending on store Project Description: What I need is that depending on the store in which the customer bought the address should change the fo

Keyword and Parameter Description: label_name: This is an undeclared identifier which optionally labels the PL/SQL block. When used, label_name should be enclosed by the do

Project Description: I want to write some SQL statements. The things I need are between pages 5-7. The only problem is that i want it till tomorrow. Skills required is SQL

Question 1. Update stock levels when the order is cancelled At times, customers make mistakes in submitting their orders and call to cancel the order. Brewbean’s wants to create a

EXCEPTION_INIT Pragma The pragma EXCEPTION_INIT relates an exception name with an Oracle error number. Which allow you to refer to any internal exception by the name and to wri

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

Using LIMIT For nested tables, that have no maximum size, the LIMIT returns NULL. For varrays, the LIMIT returns the maximum number of elements that a varray can have (that yo

Order of Evaluation When you do not use the parentheses to specify the order of evaluation, the operator precedence determine the order. Now compare the expressions below: NOT

Example of EXCEPT Operator - SQL Example, like its counterpart in the theory book, illustrates the convenience of allowing any table expression to be the source for an INSERT

Pl/sql Conditional Control: IF statements Frequently, it is necessary to take the alternative actions depending on the circumstances. The IF statement execute a series of statem