The following information needs to be recorded about

  • No School
  • AA 1
  • AgentScorpion11378
  • 2
  • 50% (4) 2 out of 4 people found this document helpful

This preview shows page 2 out of 2 pages.

Customers may have one or more accounts, although they may also have no accounts. The following information needs to be recorded about accounts: Balance, Last payment date, Last payment amount, Type. A branch may have many customers. The following information about each branch needs to be recorded: Branch Number, Location (Address, City, State, and Zip code), and Square Footage. A branch may sell all items or may only sell certain items. Orders are composed of one or more items. The following information about each order needs to be recorded: Order date, Credit authorization status. Items may be sold by one or more branches. Wally wishes to record the following about each item: Description, Color, Size, Pattern, and Type. Wally employs fifty-six employees. He would like to track the following information about employees: Name, Address (Street, City, State, and Zip code), Telephone, Date of Hire, Title, Salary, Skill, and Age. Each employee works in one and only one branch. Each employee may have one or more dependents. Wally wishes to record the name of the dependent as well as the age and relationship. Employees can have one or more skills.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture