a. Create at least two database tables for each Level One data ow diagram you created in
Question:
b. In most states, the Department of Motor Vehicles keeps records of individual driver’s licenses and vehicle license plates. Create two database tables that capture relevant information for the DMV; information in the driver’s license table would include, but not be limited to, an individual’s name, license number, and birth date. Information in the vehicle license plate table would include, but not be limited to, the license plate number and information about the vehicle itself. What foreign key(s) would you use to link the two tables together?
c. Robert Half International (www.roberthalf.net ) pairs up potential employees with companies seeking accountants and other financial information professionals. Their Web site states: “With 325 offices and 55 years of experience, Robert Half is the world’s first and largest specialized financial recruiting firm, placing quality candidates at all levels.” Point your Web browser to the company’s Web site and click the link for Robert Half United States. What information does Robert Half collect on new job seekers? Organize that information into a database table.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Accounting Information Systems basic concepts and current issues
ISBN: 978-0078025334
3rd edition
Authors: Robert Hurt
Question Posted: