Project Level 2 database Project

/in /by

 

Description

 

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now
  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:

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

);

  1. 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′);

 

  1. 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

  1. This is starting form, index.
  2. This is a form to search a student by his/her name from the database.
  3. The information on the found student can look like this:

 

  1. 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