CASE 1: CyberToys ( 50 POINTS)
You handle administrative support for CyberToys, a small chain that sells computer hardware and software and specializes in personal service. The company has four stores located at malls and is planning more.
Each store has a manager, a technician, and between one and four sales reps. The owners want to create a personnel records database, and they asked you to review a table that they had designed.
They suggested fields for store number, location, store telephone, manager name, and manager home telephone. They also want fields for technician name and technician home telephone and fields for up to four sales rep names and sales rep home telephones.
TASK:
Draw their suggested design and analyze it using the normalization concepts you learned in the chapter. What do you think of their design and why? What would you propose?
Note: For this assignment you must draw the design suggested and also your proposed design..
CASE 2: Madera Tools ( 50 POINTS)
Madera Tools operates a small business that specializes in hard-to-find woodworking tools. The firm advertises in various woodworking magazines and currently accepts mail and telephone orders.
Madera is planning a website that will be the firm’s primary sales channel. The site will feature an online catalog, powerful search capabilities, and links to woodworking information and resources.
TASK:
Madera has asked you, an IT consultant, whether a set of codes would be advantageous. What codes would you suggest?
Provide at least two choices for a customer code and at least two choices for a product code.
Describe your choices and provide some specific examples. Also include an explanation of why you selected these particular codes and what advantages they might offer.
Follow the general APA guidelines:
Your case should be typed, double-spaced on standard-sized paper (8.5″ x 11″) with 1″ margins on all sides.
Should not be less than two pages excluding the Title page.
You should use a clear font that is highly readable. APA recommends using 12 pt. Times New Roman font.
Include a page header (also known as the “running head”) at the top of every page. To create a page header/running head, insert page numbers flush right.
Then type “TITLE OF YOUR PAPER” in the header flush left using all capital letters. The running head is a shortened version of your paper’s title and cannot exceed 50 characters including spacing and punctuation.
