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

Testing triggers, Demonstrate your knowledge of PL/SQL programming by writi...

Demonstrate your knowledge of PL/SQL programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce application that provides security l

Difference between ttitle and btitle, TTITLE and BTITLE are commands in Pl-...

TTITLE and BTITLE are commands in Pl-SQL to control report headings and footers. This Ttitle & Btitle are mainly used on creating SQL*PLUS report. Ttitle is used for toptitle headi

Parameter default values, Parameter Default Values As the illustration ...

Parameter Default Values As the illustration below shows, you can initialize the IN parameters to the default values. In that way, you can pass various numbers of actual par

Block structure in pl/sql, Block Structure The PL/SQL is a block-struct...

Block Structure The PL/SQL is a block-structured language. That is, the fundamental units (procedures, anonymous blocks, and functions) that make up a PL/SQL program are logi

Effects of null for multiple assignments - sql, Effects of NULL for Multipl...

Effects of NULL for Multiple Assignments - SQL If the row expression given as the source for a multiple assignment evaluates to NULL, then NULL is assigned to each target. If

Join query, Using a join on 3 tables, select 5 columns and 10 rows from the...

Using a join on 3 tables, select 5 columns and 10 rows from the 3 tables without the use of a Cartesian product Query: SELECT E.LAST_NAME, E.FIRST_NAME, S.BUILDING, S.BRAN

I need data entry conversion project, Project Description: This is stage...

Project Description: This is stage 1 of a larger conversion project. We are converting a traditional Server/Client application written in Access 2007 into a web interface with S

Effects of null for union - sql, Effects of NULL for union - SQL The ...

Effects of NULL for union - SQL The treatment of NULL in invocations of EXCEPT is as for UNION. This is different from its treatment in those of NOT IN and quantified compari

Package dbms output in pl/sql, DBMS_OUTPUT: The Package DBMS_OUTPUT en...

DBMS_OUTPUT: The Package DBMS_OUTPUT enables you to display output from the PL/SQL subprograms and blocks, that makes it easier to test and debug them. The procedure put_ line

Data types in sql - interval, Data Types in SQL - Interval, Boolean I...

Data Types in SQL - Interval, Boolean INTERVAL for values denoting, not intervals (!) but durations in time, such as 5 years, 3 days, 2 minutes, and so on. BOOLEAN, con

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