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...
A ____ relationship means that a record in one table is related to only one record in another table. This type of relationship is rare in the world of databases.
A. many-to-many B. one-to-one C. many-to-one D. one-to-many
A(n) ____________________ gradient blends in a counterclockwise sweep around the starting point.
Fill in the blank(s) with the appropriate word(s).
To sort on a field within data that is already sorted on another field, click the ________ button in the Sort dialog box
Fill in the blank(s) with the appropriate word(s).
A network technician has been tasked with deploying new VoIP phones on a network. When the technician plugs the Ethernet cable for the phone into the wall port, the phone fails to turn on. When the technician plugs the Ethernet cable directly into the computer, the computer is able to access the network. Which of the following is the MOST likely cause of this issue?
A. The network switch does not support PoE B. The technician is connecting the phone to the wrong type of port C. The firewall on the network is blocking access to the DHCP server D. The Ethernet cable is the wrong type