Introduction a*Fashion is a family-owned business established in 1970 at Sunnybank, Brisbane. Now it is a popular fashion brand for young adults across Australia. The proprietors of a*Fashion have approached you and asked if you could design a database to help them manage their business. The management has commissioned you (in your capacity as a Database Management System consultant) to analyse, design and develop an appropriate conceptual data model and relational database schema, based on the following information gathered about the current business activities. Business Rules (for all students): a*Fashion operates stores in many locations across Australia. Each store has a unique identification number. In addition, a*Fashion wants to record name, phone, and email for each store. • Each store has several staff. For each staff, a*Fashion records their ID, first name, last name, phone, date of birth, start date of work, appointment level, and hourly rate ($). The hourly rate depends on the level of appointment. • Each store is managed by a staff as a store manager. There are also several staff who supervise other staff within the store, but a staff can be supervised by only one supervisor. • Each store sells different types of products like t-shirts, shirts, skirts, pants, bags, etc. For each product of any type, it stores product number, description, size, price, and discount, if available. • Customer may place orders in store or online. Customer details are always taken / updated at each order. A customer is referenced by a customer number, customer first & last names, email, and phone number, if available. • A customer may order more than one product at a time, and they may order multiple copies of the same product. a*Fashion also records the date a product arrives and the date when it is picked up by the customer. Note that these dates may be different for each product. Note that a*Fashion understands that they may not have provided you with sufficient information. If you need to make assumptions about their business, please ensure that you record them.

Introduction aFashion is a family-owned business established in 1970 at Sunnybank, Brisbane. Now it is a popular fashion brand for young adults across Australia. The proprietors of aFashion have approached you and asked if you could design a database to help them manage their business. The management has commissioned you (in your capacity as a Database Management System consultant) to analyse, design and develop an appropriate conceptual data model and relational database schema, based on the following information gathered about the current business activities. Business Rules (for all students): aFashion operates stores in many locations across Australia. Each store has a unique identification number. In addition, aFashion wants to record name, phone, and email for each store. • Each store has several staff. For each staff, aFashion records their ID, first name, last name, phone, date of birth, start date of work, appointment level, and hourly rate ($). The hourly rate depends on the level of appointment. • Each store is managed by a staff as a store manager. There are also several staff who supervise other staff within the store, but a staff can be supervised by only one supervisor. • Each store sells different types of products like t-shirts, shirts, skirts, pants, bags, etc. For each product of any type, it stores product number, description, size, price, and discount, if available. • Customer may place orders in store or online. Customer details are always taken / updated at each order. A customer is referenced by a customer number, customer first & last names, email, and phone number, if available. • A customer may order more than one product at a time, and they may order multiple copies of the same product. aFashion also records the date a product arrives and the date when it is picked up by the customer. Note that these dates may be different for each product. Note that a*Fashion understands that they may not have provided you with sufficient information. If you need to make assumptions about their business, please ensure that you record them.

Related questions

Question

Draw and ERD digrame for my home work . Below are the standers that should be meet

1) Correct identification of all the entities. Entity names should follow the standard
conventions, i.e., they should be singular nouns and written in CAPITAL letters, or
at least the first letter is CAPITAL.

2) Correct identification of all the attributes for each of the entities .
Correct identification of all the relationships with appropriate connectivity and
participation. If the connectivity and/or participation are not clear from the
assignment specification, the assumptions made should be clearly stated.

3) Introduction of composite/bridging entity to represent many-to-many relationships.
4) Correct representation of strong and weak relationships (solid and dashed line)
5) Correct identification of all the primary keys and foreign keys. The primary keys
should be underlined, and foreign keys should be italic.

Transcribed Image Text:Introduction a*Fashion is a family-owned business established in 1970 at Sunnybank, Brisbane. Now it is a popular fashion brand for young adults across Australia. The proprietors of a*Fashion have approached you and asked if you could design a database to help them manage their business. The management has commissioned you (in your capacity as a Database Management System consultant) to analyse, design and develop an appropriate conceptual data model and relational database schema, based on the following information gathered about the current business activities. Business Rules (for all students): a*Fashion operates stores in many locations across Australia. Each store has a unique identification number. In addition, a*Fashion wants to record name, phone, and email for each store. • Each store has several staff. For each staff, a*Fashion records their ID, first name, last name, phone, date of birth, start date of work, appointment level, and hourly rate ($). The hourly rate depends on the level of appointment. • Each store is managed by a staff as a store manager. There are also several staff who supervise other staff within the store, but a staff can be supervised by only one supervisor. • Each store sells different types of products like t-shirts, shirts, skirts, pants, bags, etc. For each product of any type, it stores product number, description, size, price, and discount, if available. • Customer may place orders in store or online. Customer details are always taken / updated at each order. A customer is referenced by a customer number, customer first & last names, email, and phone number, if available. • A customer may order more than one product at a time, and they may order multiple copies of the same product. a*Fashion also records the date a product arrives and the date when it is picked up by the customer. Note that these dates may be different for each product. Note that a*Fashion understands that they may not have provided you with sufficient information. If you need to make assumptions about their business, please ensure that you record them.

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here