Question-II i. Generate Use Case Diagram of the following Scenario a. A Client usually orders one or more same of different products from the company. Usually there are either individual clients or corporate clients. An Employee is attached with corporate client only as Point of Contact (POC) for dlient interaction. Order can have one or more order details and in each order details there are one or more different products. As a rule-of thumb, inventory is directly attached with orders and re-orders levels are automatically updated whenever there are products added in different orders. Products are shipped by suppliers; suppliers can supply multiple products from single or multiple warehouses. Tracking of shipment of order to company is tracked from departure of product from warehouse till arrival of product at warehouse. Supplier used different logistics to ensure timely delivery of the Product. Mainly Truck or Air Services are used in-country and out of country delivery respectively

Question-II i. Generate Use Case Diagram of the following Scenario a. A Client usually orders one or more same of different products from the company. Usually there are either individual clients or corporate clients. An Employee is attached with corporate client only as Point of Contact (POC) for dlient interaction. Order can have one or more order details and in each order details there are one or more different products. As a rule-of thumb, inventory is directly attached with orders and re-orders levels are automatically updated whenever there are products added in different orders. Products are shipped by suppliers; suppliers can supply multiple products from single or multiple warehouses. Tracking of shipment of order to company is tracked from departure of product from warehouse till arrival of product at warehouse. Supplier used different logistics to ensure timely delivery of the Product. Mainly Truck or Air Services are used in-country and out of country delivery respectively

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Question 3 Draw a detailed activity Diagram in draw.io and screenshot it for me. ( **Please take note is a detailed activity diagram) Scenario The exam unit uses the system after the subject registration period has closed. The system will display a list of subjects that have registered students. Using this list, the exam unit will plan out examination week. Examination week lasts 6 days, from Monday to Saturday. For each day, the exam unit will assign a subject to that day. Each day can have a total of 6 examination hours with subjects having 2- hour or 3-hour examinations. For example, if the subjects are 2-hour examinations, then 3 of them can be scheduled for the day and if the subjects are 3-hour examinations, then only 2 of them can be scheduled for the day. There can also be a mixture of 2-hour and 3-hour examinations. If the exam unit schedules too many examination hours for that day then the day resets and the exam unit needs to reschedule again. This process stops when…
Create a use case sequence diagram using the information below. Buy Parts Customer/Store Employee Description: This use case describes car parts dealer purchasing. Successful Finish: client requests vehicle component 2. Store associate verifies availability 3. component is available and client pays cost 4. Customer receives part; stock adjusted. 1. Customer asks auto part 2. Store Associate checks part availability 3. Part is unavailable and customer chooses to order part or no part 4. Customer receives part and stock is updated (if alternate part ordered) or leaves without part. Alternative: Customer wants component. No post-condition No assumptions
Q2/II draw the entity relationship for each of the following: 1-" a student studies one or many modules and a module is studied by one or many students". 2-" a manager leads one or many employees and an employee is led by one and only one manager". 3-" a manager leads one or many employees and an employee is led by one and only one manager and if there is a manager who has no employees to lead". 4- "a classroom has one and only one lecturer to manage and a lecturer has one and only one classroom". 5- "each classroom has one or many students registered in and a student has one or many classrooms to be registered in".
In the ER diagram for a Point of Sale system, there are entities such as Cashier, Product,Checkout, Transaction, CheckoutStand, Return, Inventory, etc. Here inventory records each storagelocation and its capacity. Sometimes, a customer may need to come back to pickup their items afterchecking out while most of the time they leave the store with their purchases. Which of the following is thebetter design for manage transactions?A) Add an attriute to transaction to indicate whether goods have been pickuped or notB) Create two subtyeps of TransactionC) Create a weak entity Pickup to link with TransactionD) Add a relationship between Transaction and Product
WEEK 8 ASSIGNMENT create a star schema for the Bob's Fixit Group Case Study . The star schema needs to support the analysis or measurement of material price by suppliers, date, and jobs. Case Study Bob owns a small company called Bob’s Home repairs. He does the small home repair jobs that the large companies pass by. Need some woodwork or wood furniture fixed? Call Bob. Here is how the business works: Someone calls Bob and asks him to bid on a job. He drives over, looks at the situation, and gives them a bid. Sometimes it is an official looking bid by mail, and sometimes it is scribbled on notebook paper. He decides how long it will take to do the job (he bills by the hour), how much wood will be needed, any odds and ends that are unique to the job, and an overall price. He moves from job to job and bills customers as he finishes the work. Bob buys items and supplies from a variety of places, but he buys stuff only when it is needed for a particular project. A potential problem:…
Below is a sample of an assignment roster of employees working in a company. An assignment Involves a specific job given to a specific employee, on a specific date and time, and in a specific section of a specific building. Very specific. You've Identified the following entities: Assignment, Employee, Section, Bullding. Job. No others. Use the information below to Infer which entities have relationships with each other, as well as the types of those relationships, and constraints if any. All that you should submit is a set of the relevant business rules. Once again, remember that entitles don't necessarily directly connect, unless the information collected specifies that they are connected. In case you need extra info: • Section is a kind of code given to a section in a specific building. Each section has a completely unique code (across all buildings) e.g. F3 only exists in building "Flora", not any other building. Section N is short for "section name"; It's the name of the section •…
Assignment: Problem #7 from Chapter 4 of the textbook. The case study is United Helpers. With the use of Microsoft Visio, draw YOUR entity relationship diagram (ERD) using Crow's foot notation to indicate entities, relationships, optionalities, connectivities and cardinalities. In addition, be sure to include a heading on your ERD with a brief descriptive title, your name, and a date. It is suggest that you write out business rules but the rules do not need to be submitted. 7. How would you (graphically) identify each of the following ERM components in a Crow’s Foot notation? an entity the cardinality (0,N) a weak relationship a strong relationship
To manage the materials of a factory, please give the E-R diagrams. Such entity sets are involved as below: Warehouse: with attributes as Number, area and telephone Accessory : with attributes as number, Name, Specification, price and description Supplier: with attributes as Number, name, address, telephone and асcount Project : with attributes as number and budget Employee : with attributes as number, name and age
For the business rules given below, create a fully labeled Crow’s Foot diagram using Visio. Business rules are as follows: During peak periods, Temporary Employment Corporation (TEC) places temporary workers in companies. TEC’s manager gives you the following description of the business: TEC has a file of candidates who are willing to work and a list of companies that request temporaries. If the candidate has worked before, that candidate has a specific job history. Each time the candidate worked; one additional job history record was created. Each candidate has earned several qualifications. Each qualification may be earned by more than one candidate. Each time a company requests a temporary employee, TEC makes an entry in the Openings folder. That folder contains an opening number, a company name, required qualifications, a starting date, an anticipated ending date, and hourly pay. Each opening requires only one specific or main qualification. When a candidate matches the…
Draw a use case diagram based on the case study given below.Your diagram should contain at least 3actors, 8 use cases, and 2 include and 2 extend relationships. Shopping Made Easy System A customer uses Shopping Made Easy System for online shopping. System requires the customer to sign up and sign in to be able to interact with the system. Customer registration is verified by the administration. A customer may use the portal as a guest without signing up but is only able to view catalogues in case of a guest. A customer can manage his/her account which involves signup/sign in and profile management. A customer can browse through catalogues to view different products; customer can also search for a specific catalogue by name or code number. Customer can view the products and can log out without buying. Another main feature of the system is Shopping cart management. Customer can add or remove items in cart. Customer can check which items have…
Draw ER diagram for the following upload the diagram ?? A laboratory has several chemists who work on one or more projects. Chemists also may use certain kinds of equip- ment on each project. Attributes of CHEMIST include Em- ployee_ID (identifier), Name, and Phone_No. Attributes of PROJECT include Project ID (identifier) and Start_Date. Attributes of EQUIPMENT include Serial_No and Cost. The organization wishes to record Assign_Date-that is, the date when a given equipment item was assigned to a particular chemist working on a specified project. A. chemist must be assigned to at least one project and one equipment item. A given equipment item need not be as- signed, and a given project need not be assigned either a chemist or an equipment item. Provide good definitions for all of the relationships in this situation.
Draw an ERD for the following problem:Company organized into departments. Each department has unique, name and a particular employee who manages the department. Start date for the manager is recorded. Department may have several locations. A department controls a number of projects. Projects have a unique name, number and a single location. Company’s employees name, ssno, address, salary, sex and birth date are recorded. An employee is assigned to one department, but may work for several projects (not necessarily controlled by her dept). Number of hours/week an employee works on each project is recorded; the immediate Supervisor for the employee. Employee’s dependents are tracked for health insurance purposes (dependent name, birthdate, relationship to employee).