a. Create at least two database tables for each Level One data flow diagram you created in
Problem 6 (data flow diagram creation).
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 ( ) 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.

  • CreatedAugust 06, 2015
  • Files Included
Post your question