Reference no: EM131924859
Assignment
The "Sweet Shop" management would desire to have a database system to keep track of its chocolate items, customers, and employees. Read the following paragraph to answer the given questions.
The "Sweet Shop" has registered with a registration number, title, address and phone number. The shop has one or many employees working with it. For each employee, the system keeps an employee ID, first name, last name, address, telephone number, and salary. For each customer, the system needs to keep a customer ID, first name, middle name, last name, title, telephone number, and address. A customer can make zero or more orders. For each order, the system maintains a unique order ID, date, time, and any special discounts offered on the order. Only one employee takes each order. One employee may deal with one or more customers. A single order associated with one or more items. The item details to be stored are item ID, quantity, description, and unit price. The shop inventory stores one or many items.
1. Identify the classes and their attributes from the given paragraph.
2. Draw a Class diagram for the given database. The diagram must show all classes, relationships between classes, and multiplicities.
|
What challenges do you see in macro practice-community
: How do you see macro practice in action in our community (can use material from guest speakers, lecture, other presentations, class discussion)?
|
|
Do juries reflect the diversity of local communities
: Unfair treatment and denial of one's civil rights may be based on one's age, gender, sexual orientation, race, ethnicity or religion.
|
|
Discuss relationship between data information and knowledge
: Discuss the relationship between data, information, and knowledge. Support your discussion with at least 3 academically reviewed articles.?
|
|
Identify the situations and perspectives
: Can you identify with the situations and perspectives that he presents? Did your opinion change during the course of reading the book?
|
|
Draw a class diagram for the given database
: Draw a Class diagram for the given database. The diagram must show all classes, relationships between classes, and multiplicities.
|
|
The company policy regarding alcohol
: You are a first-year Human Resource Specialist at "State of Estates" estate planning firm. The firm is devising a new employee handbook.
|
|
Discuss the importance of knowing your system information
: Discuss the importance of knowing your system information. Why is it important to know for installing software on your system?
|
|
Describe what role your chosen staff member plays
: Identify and describe what role your chosen staff member plays in the operation of the court and some of the tasks that the individual engages into fulfill his.
|
|
Explain pluralism or assimilation specifically
: Evaluate and explain pluralism or assimilation specifically as this group's most plausible Americanization mainstream integration pathway.
|