Project Level 2 Description

Attached

Project Level 2

Description

Don't use plagiarized sources. Get Your Custom Essay on
Project Level 2 Description
Just from $13/Page
Order Essay

1. The project starts with the form collecting student name, major(s) and class(es). When the Submit button is pressed, the record is inserted into the table Students on the database Project which you must create first:

a.

create database Project;

use Project;

create table students

(STNO INT PRIMARY KEY NOT NULL AUTO_INCREMENT,

SNAME VARCHAR(20) NULL,

MAJOR VARCHAR(4) NULL,

CLASS INT NULL

);

b. Populate the table Students with the data:

insert into students values(2,’Lineas’,’ENGL’,’1′);

insert into students values(3,’Mary’,’COSC’,’4′);

insert into students values(4,’Zoya’,’ENGL’,’1′);

insert into students values(5,’Sam’,’COSC’,’4′);

insert into students values(8,’Brenda’,’COSC’,’2′);

insert into students values(10,’Richard’,’ENGL’,’1′);

insert into students values(13,’Kelly’,’MATH’,’4′);

insert into students values(14,’Lujack’,’COSC’,’1′);

insert into students values(15,’Reva’,’MATH’,’2′);

insert into students values(17,’Elainie’,’COSC’,’1′);

2. This is how the collecting form should look like. On the bottom of each screen you should provide links to all three screens:

add student |

list all students

|

search students

3. This is starting form, index.

4. This is a form to search a student by his/her name from the database.

5. The information on the found student can look like this:

6.

This is a screen providing information on the whole table Students of the Project database.

General Appearance of The Project
(Collect all your data into one Microsoft Word Document)
Page 1 – Cover sheet

· College Name

· Course Name

· Course Code

· Instructor Name

· Project Name

· Student Name and Section Number

Pages 2 to 5 – Assignment Description

· Printout the project description

Pages 6 – 10 – Web Site

· Printout of each page of your Web site

Pages 11 – 12 – Database

· Printout of the table in both Design and Datasheet Views

Calculator

Calculate the price of your paper

Total price:$26
Our features

We've got everything to become your favourite writing service

Need a better grade?
We've got you covered.

Order your paper