Design tables in 3NF. As you create the database, include various codes for at least three of the fields.
What will be an ideal response?
Sample 3NF records might look like this. Notice that the associative entity, TRAINING RECORD, has a combination primary key composed of three fields that uniquely identify a specific student in a specific course on a specific date.
Note: answers on codes will vary. Encourage students to review the material on pages 29-298and create suitable codes.
MEMBER (MEMBER ID, LASTNAME, FIRSTNAME, ADDRESS, PHONE)
INSTRUCTOR (INSTRUCTOR ID, LASTNAME, FIRSTNAME, ADDRESS, PHONE)
CLASSES (CLASS NO, COURSE NAME, DATE, DAY, TIME, TUITION FEE, INSTRUCTOR ID)
MERCHANDISE (MEMBER ID, MERCHANDISE NO, DATE, DESCRIPTION, QUANTITY, PRICE)
?
You might also like to view...
Case-Based Critical Thinking QuestionsCase 5-1Part of your new job on the Web development team is to review the page download sizes of new pages added to the site to make sure that everything added is well-considered. One of your colleagues has given you a great graphic but it's in the TIFF file format. Which of the following can you NOT use to convert it to a browser-friendly format?
A. Adobe Photoshop B. Adobe Photoshop Lightroom C. Microsoft Image Gallery D. Adobe Fireworks
Modifying a table in Design view allows you to specify fields and field properties.
Answer the following statement true (T) or false (F)
When sending a message, you cannot choose to use voting buttons.
Answer the following statement true (T) or false (F)
You can have several desktop apps on the desktop but only one open at a time.
Answer the following statement true (T) or false (F)