Question

You are tasked to design the ER diagram for the database for the 3S clothing store....

You are tasked to design the ER diagram for the database for the 3S clothing store. Data requirements are as given below.
• Information about 3S employees includes a unique employee ID, and his/her name and position.
• Each customer of 3S is identified by a customer ID, and has a name.
• Information about the suppliers of 3S include a unique name, and a contact phone number.
• Clothes stocked by 3S are described by a product code, size, colour, set price and stock quantity.
• Details of clothing brands need to be kept, including a unique brand name and any designer information.
• A piece of clothing must have at least one supplier and each supplier can supply many clothes. When a supplier supplies a piece of clothing, data includes a supply price, and the quantity and date of the supply. If a supplier provides several supplies for a piece of clothing, only data for the most recent supply is kept.
• Customers order clothes. Details of an order include date of the order and quantity of the clothes s/he orders. A customer can place several orders on a day and the details of each order need to be kept.
• Some customers are VIP customers who are issued a membership number. While a VIP customer is serviced by one service specialist (who is an employee). A service specialist cares for several VIP customers.
• VIP events about brands are organised regularly, including details such event date and format. A brand can be included in several events and an event can promote several brands. A service specialist promotes events to his/her VIP customers.
Examples of queries required by 3S:
• Look up the details of suppliers, service specialists, customers and clothes for daily operation.
• Check the stock quantity of clothes and contact suppliers for a new supply if needed.
• Find out details of events for different brands.
According to the data requirements and query requirements above, give the ER diagram for the database using the UML class diagram symbols (as used in the lecture notes and tutorials), making appropriate assumptions where necessary. You must represent entity types, relationships and their attributes, and all applicable constraints in your diagram. Explain any constraints that are not be expressed in the diagram. Note that your ER diagram would be mapped to a relational database schema and implemented as tables using a DBMS. It may be helpful that you do this mapping and see if the queries can be answered using the mapped relations to help you refine the ER diagram.

Homework Answers

Answer #1

COMMENT FOR ANY QUERIES

PLEASE GIVE AN UPVOTE

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
. Design an ER-diagram for a bank that implements the following requirements. The database you design...
. Design an ER-diagram for a bank that implements the following requirements. The database you design should store information about customers, accounts, branches and employees • Customer: Customers are identified by their SSN. For each customer we store a name, multiple phone numbers (one or more), and an occupation. • Account: Accounts are identified by an account number and the branch they belong to. For each account we store a balance and the type of account (e.g., savings). – An...
Read the directions Draw an ER diagram for a bank database. The database stores information about...
Read the directions Draw an ER diagram for a bank database. The database stores information about customers and their loans. Information about a customer includes the name, address, phone, SSN, and loan(s) the customer has. Loans have loan numbers, types (e.g. mortgage, car) and amount. Do not add any attributes other than the ones describe here. Modify your design to accommodate the following constraint(s). Each constraint is independent from one another. Again, do not add any attributes other than the...
Create a relational model and ER diagram based on the following info. Emerald Realty Group, Inc....
Create a relational model and ER diagram based on the following info. Emerald Realty Group, Inc. is a local real estate company that is specialized in leasing office space to businesses. The company does not own all the properties it leases. The company has its own suppliers and customers. We refer to the person or the company that owns the office space as a supplier. A customer is the person or the company that rents the office space. Emerald Realty...
You are working with a database that stores information about suppliers, parts and projects. The Supply...
You are working with a database that stores information about suppliers, parts and projects. The Supply relation records instances of a Supplier supplying a Part for a Project. The schema for the database used in this question is as follows: (note that primary keys are shown underlined, foreign keys in bold). SUPPLIER (SNo, SupplierName, City) PART (PNo, PartName, Weight) PROJECT (JobNo, JobName, Country) SUPPLY (SNo, PNo, JobNo, Quantity) Provide relational algebra (NOT SQL) queries to find the following information. Each...
You are a database consultant with Ace Software, Inc., and have been assigned to develop a...
You are a database consultant with Ace Software, Inc., and have been assigned to develop a database for the Mom and Pop Johnson video store in town. Mom and Pop have been keeping their records of videos and DVDs purchased from distributors and rented to customers in stacks of invoices and piles of rental forms for years. They have finally decided to automate their record keeping with a relational database. You sit down with Mom and Pop to discuss their...
Hello, can you teach me how to draw a Use Case diagram for this given scenario?...
Hello, can you teach me how to draw a Use Case diagram for this given scenario? I also need to include all the extends and includes relationships. Case Description Acme Drug Stores (ADS) which consists of a chain of retail stores across Canada wants to be able to provide a new online customer service system. Each store has an identifying store no, address, phone, and email. The company dispenses a wide range of pharmaceutical (drug) products. Each product has a...
Case Study 4: Zappos Tony Hsieh’s first entrepreneurial effort began at the age of 12 when...
Case Study 4: Zappos Tony Hsieh’s first entrepreneurial effort began at the age of 12 when he started his own custom button business. Realizing the importance of advertising, Hsieh began marketing his business to other kids through directories, and soon his profits soared to a few hundred dollars a month. Throughout his adolescence, Hsieh started several businesses, and by the time he was in college he was making money selling pizzas out of his Harvard dorm room. Another entrepreneurial student,...
GoodClothes and MIS: Case from struggle to revamp Headquartered in Dubai, GoodClothes is a highly successful...
GoodClothes and MIS: Case from struggle to revamp Headquartered in Dubai, GoodClothes is a highly successful department retailer offering completely designed casual clothing and accessories. The company operates 10 stores in all seven emirates and 1 store in Al Ain. The company owns 6 stores and franchises 5. For some time, marketing managers targeted population between the ages 40 and 60 who like loose, comfortable clothes. Then, management was tempted to stock its stores with clothes for a younger population...
What tools could AA leaders have used to increase their awareness of internal and external issues?...
What tools could AA leaders have used to increase their awareness of internal and external issues? ???ALASKA AIRLINES: NAVIGATING CHANGE In the autumn of 2007, Alaska Airlines executives adjourned at the end of a long and stressful day in the midst of a multi-day strategic planning session. Most headed outside to relax, unwind and enjoy a bonfire on the shore of Semiahmoo Spit, outside the meeting venue in Blaine, a seaport town in northwest Washington state. Meanwhile, several members of...
Sign In INNOVATION Deep Change: How Operational Innovation Can Transform Your Company by Michael Hammer From...
Sign In INNOVATION Deep Change: How Operational Innovation Can Transform Your Company by Michael Hammer From the April 2004 Issue Save Share 8.95 In 1991, Progressive Insurance, an automobile insurer based in Mayfield Village, Ohio, had approximately $1.3 billion in sales. By 2002, that figure had grown to $9.5 billion. What fashionable strategies did Progressive employ to achieve sevenfold growth in just over a decade? Was it positioned in a high-growth industry? Hardly. Auto insurance is a mature, 100-year-old industry...