Critical Thinking QuestionsCase 1-1Phil has been asked to create a database for his company. The database is to track employees and the projects on which the employees work. A project can have between 3 and 7 employees assigned to it. He has determined that he needs the following tables:Employee (Social Security Number, Employee Name, Street Address, City, State, Postal Code, Date Hired, Hourly Pay Rate, Project Code)Project (Project Code, Project Name, Completion Date)Which field in the Employee table should be the primary key and why?
What will be an ideal response?
Social Security Number should be the primary key because the values in the field will be unique for each record.
You might also like to view...
Define two classes, Patient and Billing, whose objects are records for a clinic. Derive Patient from the class Person given in Listing 8.1. A Patient record has the patient’s name (defined in the class Person) and identification number (use the type String). A Billing object will contain a Patient object and a Doctor object (from Practice Program 2). Give your classes a reasonable complement of constructors and accessor methods, and an equals method as well. First write a driver program to test all your methods, then write a test program that creates at least two patients, at least two doctors, and at least two Billing records and then displays the total income from the Billing records.
This project sounds reasonable until an attempt is made to put Doctor and Patient objects in the Billing class. A Billing object actually needs just the doctor’s name, patient’s name, and doctor’s office fee. The approach taken in the solution shown here is to require a Doctor and a Patient object in the constructor for a Billing object, then use Doctor and Patient accessor methods to set the parameter values for the Billing object.
________ allows to you view formatting changes to selected text without actually applying those changes
Fill in the blank(s) with correct word
One way to organize your computer or your USB flash drive is to place files that have similar purposes into ________ that have names that describe their content
Fill in the blank(s) with correct word
____ are special characters that define the pattern matching rules in a regular expression.
A. Specialchars B. Patterncharacters C. Expressionchars D. Metacharacters