Use SQL for this assignment Lab 1 Objective Create tables Steps 1. Create a tabl

Question

Use SQL for this assignment

Lab 1 Objective Create tables Steps 1. Create a table called tblGrade with columns StudentID, StudentName, Homework 1, Homework 2, term, Final Student Id Data Type: Text Field Size: 9, Input Mask: 000 -00-0000, Required: Yes, Allow Zero Length: No, Indexed: Yes (No Duplicates) Set as the primary key Student Name Data Type: Text Field Size: 50, Required: Yes, Allow Zero Length: No Homework 1 Data Type: Number Field Size: Integer, Decimal Places: 0, Required: Yes Homework 2 Data Type: Number Field Size: Integer, Decimal Places: 0, Required: Yes Midterm Data Type: Number Field Size: Integer, Decimal Places: 0, Required: Yes Final Data Type: Number Field Size: Integer, Decimal Places: 0, Required: Yes

Explanation / Answer

1. Create table tblGrade(StudentId varchar2(9) PRIMARY KEY, StudentName varchar2 (50) NOT NULL, Homework1 integer, Homework2 integer, Midterm integer,Final integer) ;

The above statement will create the table called tye tblGrade with the student id as primary key with other columns.

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.