Homework Help is Here – Start Your Trial Now!
Engineering
Data Structures and Algorithms
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.

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.

icon
Related questions
Question

Hi for my home work can you draw a ERD digram and also convert it into a relational database schema .thanks 

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.
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.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer