Create an Entity-Relationship Model to represent the data requirements of the problem given below. Specify the cardinalities of relationships and all-important constraints. Also mention the assumptions if you have made any. A Medical store has many branches throughout country. The data held on each branch is the branch address made up of street, city, and zip code, and telephone number. Each branch is given a branch number, which is unique throughout the country. Each branch is allocated at least one staff member. Each staff member must belong to exactly one branch. The data held on a member of staff is his or her name, position and salary. Each member of staff is given a staff number, which is unique throughout the country. Each branch has a one or many products. A product belongs to exactly one or many branches. The data held on a product is the product number (identifier), title, category, price, and available quantity. Each product is purchased from exactly one vendor. From one vendor one or more than one products can be purchased. There will be no vendor from which none of the product is purchased. For vendor; v_id (identifier), v_name, v_address, and v_contact have to be stored. Vendor can have multiple contact numbers. Purchased date, purchased quantity also has to be stored. A product is sold out to at most one customer. There are some customers to whom many products are sold out. There will be no customer to whom none of the product is sold out. There are some products which are not sale out to any customer. For sold out event; sale id, sale time, total amount, product number, item number have to be stored. For customer cid, cname and caddress is required to be stored. cid is used as primary key.
Create an Entity-Relationship Model to represent the data requirements of the problem given below. Specify the cardinalities of relationships and all-important constraints. Also mention the assumptions if you have made any.
A Medical store has many branches throughout country. The data held on each branch is the branch address made up of street, city, and zip code, and telephone number. Each branch is given a branch number, which is unique throughout the country. Each branch is allocated at least one staff member. Each staff member must belong to exactly one branch. The data held on a member of staff is his or her name, position and salary. Each member of staff is given a staff number, which is unique throughout the country. Each branch has a one or many products. A product belongs to exactly one or many branches. The data held on a product is the product number (identifier), title, category, price, and available quantity. Each product is purchased from exactly one vendor. From one vendor one or more than one products can be purchased. There will be no vendor from which none of the product is purchased. For vendor; v_id (identifier), v_name, v_address, and v_contact have to be stored. Vendor can have multiple contact numbers. Purchased date, purchased quantity also has to be stored. A product is sold out to at most one customer. There are some customers to whom many products are sold out. There will be no customer to whom none of the product is sold out. There are some products which are not sale out to any customer. For sold out event; sale id, sale time, total amount, product number, item number have to be stored. For customer cid, cname and caddress is required to be stored. cid is used as primary key.
Step by step
Solved in 2 steps with 1 images
