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.
Computer Science & Information Technology
You might also like to view...
After a successful compile, you can run the class file on any computer that has a ____.
A. Java language interpreter B. Web browser C. text editor D. DOS
Computer Science & Information Technology
fputc() is the general form of ____.
A. fput() B. putc() C. putchar() D. fputchar()
Computer Science & Information Technology
System failure can occur because of a hardware problem, a software problem, or computer sabotage.
Answer the following statement true (T) or false (F)
Computer Science & Information Technology
A(n) ____________________ is high-speed memory built into the CPU that temporarily stores data and intermediary results during processing
Fill in the blank(s) with the appropriate word(s).
Computer Science & Information Technology