What is the SQL statement needed to insert a new field in the Student table that would store the total number of credits each student has accumulated? What data type should we use, and why?
What will be an ideal response?
```
ALTER TABLE Student ADD credits TINYINT;
A TINYINT can be used because the number of credits a student has remains a relatively small number.
```
Computer Science & Information Technology
You might also like to view...
Create a method that draws an X across the current picture using dashed lines.
What will be an ideal response?
Computer Science & Information Technology
Productivity software suites are available as web-based software
Indicate whether the statement is true or false
Computer Science & Information Technology
If no broadcasts are detected from the active monitor or any one of the standby monitors, a ring goes into a ____ condition.
A. signaling B. beaconing C. messaging D. broadcasting
Computer Science & Information Technology
The ____________ principle of good database design is to organize data in the tables so that redundant data does not occur.
A. first B. second C. third D. fourth
Computer Science & Information Technology