1 / 25

Chapter 01

Chapter 01. Managing Student Type Information. Content. I. Managing Student Type Information Problem II. Solution. I. Managing Student Type Information Problem. At SaigonTech , there are three types of students: urban, suburb, province.

keziah
Download Presentation

Chapter 01

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Chapter 01 Managing Student Type Information

  2. Content I. Managing Student Type Information Problem II. Solution

  3. I. Managing Student Type Information Problem • At SaigonTech, there are three types of students: urban, suburb, province. • Each student type has its amount of discount fee, the urban student will be discounted 0% of tuition, the suburb student is 5% and the province student is 10%. • SaigonTech college wants to store all information about its student types.

  4. II. Solution 1. Logical Design 2. Physical Design 3. Implementation

  5. 1. Logical Design

  6. 2. Physical Design

  7. 3. Implementation 3.1 Using GUI mode 3.2 Using Console mode

  8. 3.1 Using GUI mode 3.1.1 Creating Database 3.1.2 Creating Table 3.1.3 Inserting Data 3.1.4 Testing – Checking the inserted data

  9. 3.1.1 Creating Database • Create a database named STUDENT_INFO • Right click on Databases group in the Object Explorer panel  Choose New Database • Database Name: STUDENT_INFO

  10. 3.1.2 Creating Table 3.1.2.1 Creating a new table 3.1.2.2 Creating Columns 3.1.2.3 Setting data type 3.1.2.4 Setting primary key

  11. 3.1.2.1 Creating a new table • Create a table named STUDENT_TYPE • Right click on the Tables group  Choose New Table • In the Properties panel, type the table name: STUDENT_TYPE

  12. 3.1.2.2 Creating Columns Create columns for table STUDENT_TYPE: STUDENT_TYPE_ID, STUDENT_TYPE_NAME, DISCOUNT, NOTES.

  13. 3.1.2.3 Setting data type Choose appropriate data type for each column: STUDENT_TYPE_ID: int; STUDENT_TYPE_NAME: varchar(50); DISCOUNT: numeric(18,2); NOTES: text.

  14. 3.1.2.4 Setting primary key Click on the Set Primary Key button

  15. 3.1.3 Inserting Data 3.1.3.1 Opening Table 3.1.3.2 Inserting Data

  16. 3.1.3.1 Opening Table Right click on the STUDENT_TYPE table  Choose Open Table

  17. 3.1.3.2 Inserting Data Insert Data Here

  18. 3.1.4 Testing – Checking the inserted data Open the STUDENT_TYPE table again to check data

  19. 3.2 Using Console mode 3.2.1 Creating a new query tab 3.2.2 Creating database 3.2.3 Creating table 3.2.4 Inserting data 3.2.5 Testing – Checking the inserted data

  20. 3.2.1 Creating a new query tab • Click on the New Query button

  21. 3.2.2 Creating database • Use database master and SQL command: Create database STUDENT_INFO

  22. 3.2.3 Creating table CREATE TABLE STUDENT_TYPE ( STUDENT_TYPE_ID int NOT NULL, SUTDENT_TYPE_NAME varchar(50) NULL, DISCOUNT numeric(18,2) NULL, NOTES text NULL, CONSTRAINT STUDENT_TYPEPK PRIMARY KEY (STUDENT_TYPE_ID);

  23. 3.2.4 Inserting data INSERT INTO STUDENT_TYPE (STUDENT_TYPE_ID, STUDENT_TYPE_NAME, DISCOUNT, NOTES) VALUES (1, ‘Urban’, 0, ‘The urban student is not discounted.’); INSERT INTO STUDENT_TYPE (STUDENT_TYPE_ID, STUDENT_TYPE_NAME, DISCOUNT, NOTES) VALUES (2, ‘Suburb’, 0.05, ‘The suburb student is discounted 5% of tuition.’); INSERT INTO STUDENT_TYPE (STUDENT_TYPE_ID, STUDENT_TYPE_NAME, DISCOUNT, NOTES) VALUES (3, ‘Province’, 0.1, ‘The province student is discounted 10% of tuition.’);

  24. 3.2.5 Testing – Checking the inserted data Select * from STUDENT_TYPE

  25. ?

More Related