4 Western Wear Outfitters

Western Wear is a mail-order firm that offers an extensive selection of casual clothing for men and women. Western Wear plans to launch a new Web site, and the company wants to develop a new set of product codes. Currently, 650 different products exist, with the possibility of adding more in the future. Many products come in various sizes, styles, and colors. The marketing manager asked you to develop an individualized product code that can identify a specific item and its characteristics. Your initial reaction is that it can be done, but the code might be fairly complex. Back in your office, you give the matter some thought.
1. Design a code scheme that will meet the marketing manager’s stated requirements
.
2. Write a brief memo to the marketing manager suggesting at least one alternative to the code she proposed, and state your reasons.
  • Working Shoes is a multistate shoe store that offers an extensive selection of casual and dress shoes designed for men and women who work on their feet. Working Shoes plans to launch a new Web site, and the company wants to develop a new set of product codes. Currently, 250 different products exist, with the possibility of adding more in the future. Shoes and many accessories come in various sizes, styles, and colors. The marketing manager asked you to develop an individualized product code that can identify a specific item and its characteristics. Your initial reaction is that it can be done, but the code might be fairly complex. Back in your office, you give the matter some thought.

3. Suggest a code scheme that will identify each Western Wear customer.
  • The two most common code scheme are straight sequence code automatically assigned by the system and code that combine alphabetic sequence blocks. An Example of the latter might be the first four alphabetic letters of the customer last named followed by a 4-,5-, or 6-digit depend number. For example, Ivan Ray Antonio might be ANTO24533. Many Firms like this approach because it provides some indication of the customer's last name .

4. Suggest a code scheme that will identify each specific order.
  • Unless there is some other reason, the order entry system automatically assigns order numbers dependently. If it is desirable to code the source of the order (such as W for Web-based, or T for telephone), you could devise a code that includes an identifying character for this purpose.

Mga Komento

Mag-post ng isang Komento

Mga sikat na post sa blog na ito

New Century Health Clinic

Imahe
New Century Health Clinic offers preventive medicine and traditional medical care. In your role as an IT consultant, you will help New Century develop a new information system. Background After completing the user interface, input, and output design for the new information system at New Century, you will consider data design issues. Begin by studying the DFDs and object-oriented diagrams you prepared previously and the rest of the documentation from the systems analysis phase. Perform the following tasks: Assignments 1. Create an initial entity-relationship diagram for the New Century Health Clinic system. 2. Normalize your table designs PATIENT ( PATIENT_NUMBER , PATIENT FIRST NAME, PATIENT LAST NAME, DATE  OF BIRTH, HOUSEHOLD NUMBER, RELATIONSHIP CODE)   APPOIN TMENT ( APPT NUMBER , PATIENT NUMBER, APPOINTMENT DATE,  APPOIN TMENT TIME, PROVIDER NUMBER) APPT_SERVICE ( APPT_SERVICE_NUMBER , APPT NUMBER, CPT CODE, STATUS, FEE, EXPLANATION) PR...
Magbasa nang higit pa

3 Mayville Public Library

Imahe
Mayville is a rural village with a population of 900. Until now, Mayville was served by a bookmobile from a larger town. The Mayville Village Council has authorized funds for a small public library, and you have volunteered to set up an information system for the library. Assume that the library will have multiple copies of certain books. 1. Draw an ERD for the Mayville library system 2. Indicate cardinality. 3. Identify all fields you plan to include in the tables. USER ( UserID , Name, BorrowLimit, NumberCheckeOut, FinesDue) AUTHOR ( AuthorID , AuthorName, BirthDate, CountryOfBirth, DeathDate) BOOK ( CallNo .,AuthorID,ISBN,Publisher, DatePublished) COPY ( CallNo, CopyNo , DateAcquired, Condition, CheckoutStatus) BOOK_CHECKOUT ( CallNo, CopyNo, UserID , DateOut, DateDueBack) CHECKOUT_LIST ( CallNo, UserID, DateRequested ) 4. Create 3NF table designs. USER ( UserID , Name, BorrowLimit, NumberCheckeOut, FinesDue) AUTHOR ( AuthorID , AuthorName, BirthDate, Count...
Magbasa nang higit pa