Design one or more tables for managing a list of courses run by your university. How many tables do you need? What fields are in each table? Be sure to include such data as the instructor’s names, number of credits, department that offers the course, and the current enrollment in the course.
What will be an ideal response?
```
Table: Course; Fields: number, name, description, credits, department, enrollment, instructorId
Table: Instructor; Fields:id, firstName, lastName, department
```
You might also like to view...
What is the effect of the following code fragment?
``` c = -1; for ( int i = MAX_SIZE - 1; i >= 0; --i ) if ( list1[i] == t ) c = i; ``` a. calculates 1 less than the sum of the occurrences of the value of t in list1 b. finds the subscript of the first occurrence of the value of t in list1 (or –1 if it is not found ) c. counts the number of occurrences of –1 in list1 d. counts the number of occurrences of the value of c in list1
Why is it important to support legacy architectures?
What will be an ideal response?
Draw a flowchart for the program fragments (no need to show start and stop).
``` IF value = 0 THEN OUTPUT "Value equals zero" END IF ```
Detail data does not refer to the subtotaled rows that are totaled and summarized
Indicate whether the statement is true or false