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

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter1: Overview Of Database Concepts

Section: Chapter Questions

Problem 3MC

See similar textbooks

Similar questions

Draw an ER diagram for the EMU Slimming Center based on the specification given below. Case Study 01 There are many dietitians in the center. There are also many clients in the center. A dietitian gives a menu to a client every week. Many diet menus are available. A diet menu consists of many food items and each food items belongs to one food category. Instructions • Identify the relationship between Entities (clearly showing the cardinality and participation)
Given the following business scenario, create a Crow’s Foot ERD using a specialization hierarchy if appropriate. Eastern Sales Company keeps information on employees and the departments that they work in. For each department, the department name, internal mail box number, and office phone extension are kept. A department can have many assigned employees, and each employee is assigned to only one department. Employees can be salaried employees, hourly employees, or contract employees. All employees are assigned an employee number. This is kept along with the employee’s name and address. For hourly employees, hourly wage and target weekly work hours are stored (e.g. the company may target 40 hours/week for some, 32 hours/week for others, and 20 hours/week for others). Some salaried employees are salespeople that can earn a commission in addition to their base salary. For all salaried employees, the yearly salary amount is recorded in the system. For salespeople, their…
Given the following business scenario, create a Crow's Foot ERD using a specialization hierarchy if appropriate. Two-Bit Drilling Company keeps information on employees and their insurance dependents. Each employee has an employee number, name, date of hire, and title. If an employee is an inspector, then the date of certification and certification renewal date should also be recorded in the system. For all employees, the Social Security number and dependent names should be kept. All dependents must be associated with one and only one employee. Some employees will not have dependents, while others will have many dependents.
Using the Crow’s Foot methodology, create an ERD that can be implemented for a medical clinic, using at least the following business rules: A patient can make many appointments with one or more doctors in the clinic, and a doctor can accept appointments with many patients. However, each appointment is made with only one doctor and one patient. Emergency cases do not require an appointment. However, for appointment management purposes, an emergency is entered in the appointment book as “unscheduled.” If kept, an appointment yields a visit with the doctor specified in the appointment. The visit yields a diagnosis and, when appropriate, treatment. With each visit, the patient’s records are updated to provide a medical history Each patient visit creates a bill. Each patient visit is billed by one doctor, and each doctor can bill many patients. Each bill must be paid. However, a bill may be paid in many installments, and a payment may cover more than one bill. A patient may pay the bill…
I need an ER diagram for the following information For Hotel: HotelID (unique) and ANoOfRooms (number of rooms in the hotel) For Hotel: HotelID (unique) and ANoOfFloors (number of floors in the hotel) For each Room: RNO (partially unique, unique in the hotel) and ANoOfBeds (number of beds in the room) For each customer: CID (unique), CName (unique), For each manager: MID (unique), MFullName (composed of MFName and MLName), MBonus (not every manager has a bonus), MSalary, multiple MPhones For each employee: EID (unique), EName Each hotel has one or more rooms Each room is located on exactly one floor Each room is cleaned by one or two employees Each employee cleans 1-3 floors Each employee cleans 6-15 rooms Each customer has one or many rooms Each customer has booked one or mamy rooms Each room is booked by a customer or no one Each floor has one or many rooms Each manager resides in exactly one room Each manager resides on exactly one floor Each hotel either has one manager residing…
Create and ERD based on the Crow's Foot Model, using the following requirements. Include Primary Keys, Foreign Keys, and Relationship types (weak/strong): 1. An INVOICE is written by a SALESREP. Each sales representative can write many invoices, but each invoice is written by a single sales representative. 2. The INVOICE is written for a single CUSTOMER. However, each customer can have many invoices. 3. An INVOICE can include many detail lines(INV_LINE), each of which describes one product bought by the customer. 4. The product information is stored in a PRODUCT entity. 5. The product's vendor information is found in a VENDOR entity.
Develop an entity-relationship model for the following scenario. A piano manufacturer wants to keep track of all the pianos it makes individually. Each piano has an identifying serial number and a manufacturing completion date. The manufacturer has piano technicians who are responsible for inspecting the instruments before they are shipped to the customers. Each piano is inspected by one or more technicians (identified by their employee number). For each separate inspection, the company needs to record its date and a quality evaluation grade.
Consider the following scenario: you've been tasked with developing a logical model of a school or college's registration system. Is a top-down strategy preferable, or is a bottom-up approach preferable in this situation? What considerations could have an influence on your decision?
Draw an ER Diagram for the following Business Situation: A bank has a phone call system in which the costumer can call and talk to one employee and inquire of their existing account. Costumer can have two type of accounts, checking account or savings account, client can own both type of accounts. One of the assumptions which is being made with this project is all interactions will be over the phone. Clients would call in to the business’ account representatives who will have to search the client in internal database. Once the client has been searched in the database, representative will go forth and verify the client via personal information displayed through the database. Personal Information would include, full name, address, last 4 of social security, and account number. The project will assume that the business is domestic, and all clients are in the United States. Once the client is verified, representative can discuss business related queries, including transactional questions…
In the space provided below, draw an ER diagram that includes entities for Clients, Contracts, and Contacts. Clients have the following attributes: ClientID (primary key), ClientName, ClientAddress. Contracts have the following attributes: ContractID (primary key), ContractType, LicenseFee. Contacts have the following attributes: ContactID (primary key), ContactName, ContactAddress. Draw a relationship between Clients and Contracts such that a Client can be assigned to many contracts, but it can also exist without having any contracts at all in the database. Conversely, a contract can be assigned to only one client but must be assigned to a client in order to exist. Name your relationship “Signs”. Draw a relationship between Clients and Contacts such that a client must be assigned to one and only one contact. A contact can exist in the database without being assigned to a client, but a contact can be assigned to more than one client. Name your relationship “Has”. Use…
There are many dietitians in the center. There are also many clients in the center. A dietitian gives a menu to a client every week. Many diet menus are available. A diet menu consists of many food items and each food items belongs to one food category. • Identify the relationship between Entities (clearly showing the cardinality and participation) The question is very clear slove it according to it
Consider the following scenario and draw a context diagram of the Estate Agency. Clients wishing to put their property on the market visit the estate agent, who will take details of their house, flat or bungalow and enter them on a card which is filed according to the area, price range and type of property. A similar type of card is filed by potential buyers. Weekly, the estate agent matches the potential buyer's requirements with the available properties and sends them the details of selected properties. The estate agent checks the sale status with the buyer and when a sale is completed, the buyer notifies the estate agent about the sale. Then the client details are removedfrom the property file, and an invoice is sent to the client. The client receives the top copy of a three part set, with the other two copies being filed. On receipt of the payment the invoice copies are stamped and archived. Invoices are checked on a monthly basis and for those accounts not settled within two…