Question

Make Java program with the following tasks:

1. Create a new database called DTCC

2. Create a table called Students in the DTCC database with the following fields:

    Student_ID    CHAR (10) ** make sure to set this field as the primary key

    LastName      CHAR(20)

    FirstName     CHAR(15)

    PlanOfStudy CHAR(25)

    GPA               Double

3. Insert 5 records into Students table:

899090111    Rothlisberger   Ben          CIT                                       3.7

129020202    Manning          Peyton     Computer Programming       3.8

890101030    Brady               Tom         Accounting                           3.4

980191919    Rodgers           Aaron       Networking                          3.2

807223230    Manning           Eli             Securities                            3.7

4. Update record Tom Brady so that his plan of study is Web Technologies

5. Update record Eli Manning so that his first name is Ellis and GPA is 4.0

6. Delete record Rothlisbeger

7. Redisplay all records (SELECT statement)

Answer 1

1. create database DTCC;

2. use DTCC;

create table students( student_id char(20), lastname char(20), firstname char(15), planofstudy char(25), gpa double, PRIMARY KEY(student_id ));

3. Insert into students(student_id, lastname, firstname, planofstudy, gpa) values(899090111, 'Rothlisberger', 'Ben', 'CIT', 3.7);

Insert into students(student_id, lastname, firstname, planofstudy, gpa) values(129020202 , 'Manning', 'Peyton', 'Computer Programming', 3.8);

Insert into students values(890101030, 'Brady', 'Tom', 'Accounting', 3.4);

Insert into students values(980191919, 'Rodgers', 'Aaron ', 'Networking', 3.2);

Insert into students values(807223230, 'Manning', 'Eli', 'Securities', 3.7);

4. Update students set planofstudy='Web Technologies' where lastname='Brady' and firstname='Tom'