Visit two local small businesses, one in the service sector (e.g., dry cleaner, auto repair shop, veterinarian, or bookstore) and one that manufactures tangible goods. Interview employees from these organizations to elicit from them the entities, attributes, and relationships that are commonly encountered in these organizations. Use this information to construct E-R diagrams. What differences and similarities are there between the diagrams for the service- and the product-oriented companies? Does the E-R diagramming technique handle both situations equally well? Why or why not?

Visit two local small businesses, one in the service sector (e.g., dry cleaner, auto repair shop, veterinarian, or bookstore) and one that manufactures tangible goods. Interview employees from these organizations to elicit from them the entities, attributes, and relationships that are commonly encountered in these organizations. Use this information to construct E-R diagrams. What differences and similarities are there between the diagrams for the service- and the product-oriented companies? Does the E-R diagramming technique handle both situations equally well? Why or why not?

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 entity-relationship diagram that describes the following business environment. Orlando Junior Baseball wants to maintain information about its teams, their coaches, players, and bats. The information about players is historic. For each team, the league wants to keep track of all of the players who have ever played on the team, including the current players. For each player, it wants to know about the player’s name, age, and every team the player ever played for. Currently and historically, each team has and has had many players. To be of interest to the league, a player must have played on at least one and possibly many teams during his career. The league wants to keep track of each team’s team number, which is unique, its name, the city in which it is based, and the name of its manager. Coaches have a name (which is only assumed to be unique within its team) and a telephone number. Coaches have units of work experience, which are described by the type of experience and…
Please DRAW a normalized ER diagram for the following situation: Unidiner is a university dining service organization that provides dining services to a major university.The following describes part of the business.Develop a conceptual ER diagram that captures business facts● The organization sets up a team of its staff to work on each event. Each staff has a name, salary, and some skills. Each staff can be part of different teams.● The organization assigns one of the staff as the supervisor of the team who supervises the team during the event.● Each event has a date, location and time.● For each staff in a team, there is a working start time, working end time and position defined.● The organization has menus. For each event, the university chooses one of the menus to be served at the event. Each menu has a description and a type.● Each menu contains several dishes, and each dish could be included in different menus. Each dish has a name, preparation time and some ingredients.Please…
Using the Entities and Attributes you created for your business from the week 1 discussions. Show the tables and relationships resulting from your model in the form of an E/R diagram. You can use PPT, VISIO or any other graphical modeling tool to create your ER diagram. Please don't post from Chegg which is already solved.
Draw an Entity Relationship Diagram for the proposed system based on therequirements showing the Entities, Attributes and Cardinality between entities. Entities and Attributes Flavor Attributes: FlavorID, Name, Description Inventory Attributes: InventoryID, FlavorID, Quantity, ReorderThreshold Sale Attributes: SaleID, CustomerID, FlavorID, Date, Quantity, TotalAmount Customer Attributes: CustomerID, Name, Email, Phone Feedback Attributes: FeedbackID, CustomerID, Comment, Date, Rating Supplier Attributes: SupplierID, Name, ContactInfo Order Attributes: OrderID, SupplierID, FlavorID, OrderDate, Quantity, DeliveryDate Forecast Attributes: ForecastID, FlavorID, PredictedDemand, Date Relationships and Cardinality Flavor - Inventory One Flavor can have multiple inventory records. (1:N) Flavor - Sale One Flavor can be part of multiple sales. (1:N) Customer - Sale One Customer can have multiple sales. (1:N) Customer - Feedback One Customer can…
Create an ER DIAGRAM that shows relationship between eachother and post the picture please . An Inventory entity can be associated with zero or many Beer entities. A Beer entity can be associated with one and only one Inventory entity. An Inventory entity can be associated with zero or one Brewery entity. A Brewery entity can be associated with zero or many Inventory entities. An Employee entity can be associated with one and only one Brewery entity. A Brewery entity can be associated with zero or many Employee entities. An Employee entity can be associated with zero or many Order entities. An Order entity can be associated with one and only one Employee entity. These business rules assume that a brewery company has an inventory of beers, which are brewed by one or more breweries and supplied by one or more suppliers. The breweries employ one or more employees and can receive orders for their beers.
Draw an Entity relationship diagram (ER) for a university according to the following rules: +-- For each student the university needs to keep track of: first name, last name, student id, address, phone no and their major. - The student id is identical for each student. -- Each course has a number, name and credit. The course number is unique for each course. + -- Each department has a name, code and location. The code is unique for each department. - Each course may has one or more sections where each section is belong to only one course. -- A department offers one or many courses. 7- Some courses have perquisite courses. 8- Each student could register in one or more courses. In your diagram you need to show the following: 1- The primary key for each entity. 2- The cardinality and participation between entities.
I want you to draw an ER Diagram about Human Resourses containing Entities like employee and departments ... i need The ER diagram to have complex structure and as many entities and attributes as possible
Identify the entities, relationships, key attributes and other attributes and then design the ER diagram: There are many hotels in a country. Each hotel is identified by its id, name and star rate. Each hotel provides many rooms. Rooms are identified by Room no. and type. Each room is rented for a cost. Cost is identified by its id and amount. A hotel has many facilities available with it. Facilities are identified by its id and name. A hotel is located at a particular location. Location is identified by street, town and pincode.
Draw an Entity Relationship Diagram (ERD) using Unified Modelling Language (UML) notation according to the below business rules. Your design should be at the logical level – include primary and foreign key fields and remember to remove any many-to-many relationships. Business rules for hairdressers: 1. All entities should have surrogate primary keys. 2. Each hairdresser can work at multiple different salons over time, and every salon employs many different hairdressers. 3. The job title of a hairdresser at a specific salon must be stored in the database. 4. The name and surname of each hairdresser must be stored in the database. 5. The name of each salon must be stored in the database. 6. Every hairdresser is certified to have several different skills, and each skill can be mastered by many different hairdressers. 7. The name of each skill must be stored in the database. 8. The date that a specific hairdresser was certified to have a specific skill must be stored in the database.
Create an Entity-Relationship (E-R) model for a new company that recently started a business where they buy highly discounted items in bulk from different companies who are going out of business or need to get rid of additional items to save warehouse space. This new company has retail stores in big cities across the country where they sell the items to individuals. They also do business as wholesalers where they sell items in bulk to local retailers in small cities. Therefore, they have two types of customers: individuals and small retailers. The company has four departments: purchase, warehouse, sales (retail and wholesale) and accounting. They employ five different types of employees: managers, accounting staffs, warehouse staffs, retail associates, and purchase agents. Each staff, agent and associate works under a manager of the respective department. Purchase agents hunt for discount items, and they get a commission based on the items they are successfully able to buy. You have…
Draw an Entity Relationship Diagram (ERD) using Unified Modelling Language (UML) notationaccording to the below business rules. Your design should be at the logical level – include primaryand foreign key fields and remember to remove any many-to-many relationships.Sheep farm feed supplier business rules:• All entities must have surrogate primary keys.• A contact person represents one or more suppliers, and each supplier has exactly onecontact person.• A supplier supplies many feed products, and every feed product can be supplied by manysuppliers.• Each feed product belongs to a specific feed type, and many feed products can have thesame feed type.
Draw an entity diagram diagram for a car rental business identifying primary and foreign keys with the below attributes and cardinality Customer - Customer_ID (pk), Cust_Title, FirstName, LastName, DoB, Telephone, Address1, Address2, City, State, ZipCode Employee - Emp_ID (pk), Firstname, lastname, Telephone, Address, City, State, ZipCode, hiredate, SSN Car - Car_ID (pk), Model, Make, Year, Color, capacity, Customer_ID (fk), Payment_ID (fk) Payment - Payment_ID (pk), PaymentType, PaymentMethod, payment amount, Signature, PaymentDate, Receipt_ID (fk) Receipt - Receipt_ID (pk), Bill_To, Receipt_Total, Total_Amt_Due, Amt_Paid, CreateDate, Payment_ID (fk) Relationship and Cardinality Description Customer/Car: 1:M - one customer can have multiple cars on file, a car must belong to a customer Employee/Customer:1:M - One employee can have many customers to attend to but just one customer can be attended to at a time. Car/Payment: 1:M - one car can have multiple payment options on file,…