Please help me quickly I will vote your answer We need to develop a COMPANY system. The company is organized into departments.Each department has a unique number, name, and telephone. A department may haveseveral locations. Each department controls number of projects. Each project has aunique number, name, and is located at a single location. For each employee, we storeunique employee's number, name, address (country, city, Box#), salary, job, and hire date.Each employee works in one department but may work for several projects, and theproject contains many employees. We keep track of the number of hours per week that anemployee currently works on each project. Employees are grouped into: (Secretary,Engineer, Technician) based on the employee's Job, and into (Salaried-employee, Hourly-employee) based on the employee's method of pay. For Secretary, we store the typingspeed, for Engineer we store Engineering type, and for Technician we store Techniciangrad. For Salaried employee we store the salary, and for Hourly employee we store the payscale.1. Draw the EERD diagram of the COMPANY system?2. Map the EERD diagram in Question 1 to the corresponding database model (( DBSchema)ABOWOR

To address the requirements presented in the image you've shared, let's break down the steps to…

Answered: We need to develop a COMPANY system.…

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

1)Modeling: Make a CDM from the following scenario: * A retail company wants to manage their sales activity. We have the following information- The date of sale, with the possibility of rolling up to the week, month, quarter and year- the store where the sale was made: store name, brand, address, city, department and region. - The employee associated with each sale: surname, first name, date of birth, social security number. Each employee is associated with a store.the customer who purchased the product surname, first name, date of birth, address. The product sold product name, d - iption, category, unit price. The order: quantity sold, amount of turnover, amount of margin. A transaction can consist of one or more orders. The indicators (quantity, turnover, margin) can be negative if it is a reimbursement. 2) In your MCD above, what are the dimension tables? * 3)In your MCD above, what are the fact tables?
This is the problem Create a complete ERD in Crow’s Foot notation that can be implemented in therelational model using the following description of operations. Hot Water (HW) is asmall start-up company that sells spas. HW does not carry any stock. A few spas areset up in a simple warehouse so customers can see some of the models available, butany products sold must be ordered at the time of the sale.• HW can get spas from several different manufacturers.• Each manufacturer produces one or more different brands of spas.• Each and every brand is produced by only one manufacturer.• Every brand has one or more models.• Every model is produced as part of a brand. For example, Iguana Bay Spas is amanufacturer that produces Big Blue Iguana spas, a premium-level brand, andLazy Lizard spas, an entry-level brand. The Big Blue Iguana brand offers severalmodels, including the BBI-6, an 81-jet spa with two 6-hp motors, and the BBI-10,a 102-jet spa with three 6-hp motors.• Every manufacturer is…
Consider the following scenario and draw an E-R diagram for Cathay airlines. Cathay Airlines stores details about an airline’s fleet, flights, and seat bookings. The airline has one or more airplanes and an airplane has a model number, a unique registration number, and the capacity to take one or more passengers. An airplane flight has a unique flight number, a departure airport, a destination airport, a departure date and time, and an arrival date and time. Each flight is carried out by a single airplane. A passenger has given names, a surname, address and a unique email address. . Each address is made up of a street, a city and a postcode. A passenger can book a seat on a flight.
Draw an E-R Diagram for: -Customers pay with credit cards. -Customers have: id, name, address, phone -Credit cards have: type, number, exp_date, ccv_number, zip_code -Each customer can pay with several credit cards -Each credit card belongs to only one customer
In this unit, we explore the structured approach to modeling business processes. In this practical assignment, using the business process of a fictional package delivery service (a courier company) called On the Spot Courier Services, you will create data flow diagrams that demonstrate the business processes that would need to be supported by a new system. Scenario: When Bill got an order, at first, only on his phone, he recorded when he received the call and when the shipment would be ready for pickup. Sometimes, customers wanted immediate pickup; sometimes, they were calling to schedule a later time in the day for pickup. Once he arrived at the pickup location, Bill collected the packages. It was not uncommon for the customer to have several packages for delivery. In addition to the name and address of the delivery location, he also recorded the time of pickup. He noted the desired delivery time, the location of the delivery, and the weight of the package to determine the courier…
Consider a scenario where a lead software development company in Silicon Valley has hired you to build its organization’s hierarchical software. After completely understanding the hierarchy, apply your knowledge of data structures to, give the code that you would write to find the lowest level and top level employee? Note: use C++ programming language . Use tree data structure.
Make class diagrams in star uml, locating the respective relationships and methods: 1. Each client has a single discount and a single credit limit. 2. A customer can have more than one delivery address. 3. Each provider has a unique address and a unique credit limit. 4. Each supplier can have several payment terms. 5. Items, like deposits, are coded. 6. An item may be stored in more than one warehouse. 7. An item will have a unique location and quantity in each warehouse where it is is stored. 8. An item may be supplied by several suppliers, but the unit price of each provider may be different. 9. Purchase order numbers can be repeated for different customers, but not for the same client. 10. Each purchase order has a unique dispatch address and a unique date. 11. A purchase order can contain one or more items, but can only do a single order for each item. 12. Purchase orders are numbered. 13. A supplier purchase order can include several items, but one item does not It can appear more…
Suppose a business person launches new cinema at Islamabad and ask his team to develop a ticket system for box office. He assigns some requirements about system that how should it work. The requirements are such a way that there are only '5' number of box office windows in the theatre. Each window can have at max '20' number of people waiting in line. To start with, only one window is opened. If the number of people waiting in line in that window exceeds 20, then the next window is opened and people can join the line in that window. Likewise, if both the first and second windows have n number of people waiting in each queue, then a third window is opened. This can go on until the maximum number of windows w is reached. Let us assume that once a window is opened it never closes. A new window is only opened if all open windows are full. Each person can buy only one ticket. So, the system should not allot more than one ticket per person. Let us assume that the system issues one ticket…
Consider a school system in which data is recorded about the movie industry. The data requirements are summarized as follows: Each subject is owned by a department and each department ismanaged by a teacher, called Head of Department (HOD). Eachdepartment has a name and a unique code number. Each subjecthas a name, unique number and credit value. All teachers have aunique ID. A HOD cannot manage more than one department at atime. Also, a HOD does not teach subjects. A subject cannot betaught by more than one teacher. Finally, the system needs toknow each student’s contact details, including, full name, studentID, address, age and gender, as well as date of enrolment in thesubject. Design an Entity-Relationship diagram for the movie database
Develop the Java program for automate the admission process portal as mentioned below: Consider the following data/attributes for the portal Data 1: College branch information: CollegeCode, CSE, IT, ME, EE, EC, IC, CH, ICT, Rank i.e. C0001, 240, 120, 240, 60, 60, 60, 60, 0, 5 Data 2: Student Information Enrollmentno, submark1, submark2, submark3, submark4, submark5 i.e. E0001, 87, 98, 65, 50, 78, 86 Data 3: Student Choice Information Enrollmentno, choice1, choice2, choice3, choice4, choice5 i.e. E0001, C0001-CE, C0002-CE, C0003-IT, C0004-CE, C0010-IT  The portal has following functionalities: Generate random data for each data: 20 records for data 1, 30 records for data2, 30 records for data 3 (generate data 3 using data 1 and data 2.) Write down code for seat allotment according to student percentage and choiceof students. using java
Develop the Java program for automate the admission process portal as mentioned below: Consider the following data/attributes for the portal Data 1: College branch information: CollegeCode, CSE, IT, ME, EE, EC, IC, CH, ICT, Rank i.e. C0001, 240, 120, 240, 60, 60, 60, 60, 0, 5 Data 2: Student Information Enrollmentno, submark1, submark2, submark3, submark4, submark5 i.e. E0001, 87, 98, 65, 50, 78, 86 Data 3: Student Choice Information Enrollmentno, choice1, choice2, choice3, choice4, choice5 i.e. E0001, C0001-CE, C0002-CE, C0003-IT, C0004-CE, C0010-IT The portal has following functionalities: Generate random data for each data: 20 records for data 1, 30 records for data2, 30 records for data 3 (generate data 3 using data 1 and data 2.) Write down code for seat allotment according to student percentage and choiceof students. You have to use constructor, and multi-dimensional array concepts compulsory. Youmay use other concepts of Object Oriented Programming if required.…
A restaurant chain has several locations in a city (with a name and zip code stored for each), and each is managed by one manager. Each manager manages multiple restaurants. Each restaurant location has its own unique set of menus. Most have more than one menu (e.g., lunch and dinner menus). Each menu has many menu items, items can appear on multiple menus, and each menu has a price on it. A customer can visit multiple restaurants and a restaurant can have multiple customers. Represent this situation of restaurants with an E-R diagram

SEE MORE QUESTIONS

Recommended textbooks for you

Database System Concepts

Computer Science

ISBN:

9780078022159

Author:

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

Publisher:

McGraw-Hill Education

Starting Out with Python (4th Edition)

Computer Science

ISBN:

9780134444321

Author:

Tony Gaddis

Publisher:

PEARSON

Digital Fundamentals (11th Edition)

Computer Science

ISBN:

9780132737968

Author:

Thomas L. Floyd

Publisher:

PEARSON

Database System Concepts

Computer Science

ISBN:

9780078022159

Author:

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

Publisher:

McGraw-Hill Education

Starting Out with Python (4th Edition)

Computer Science

ISBN:

9780134444321

Author:

Tony Gaddis

Publisher:

PEARSON

Digital Fundamentals (11th Edition)

Computer Science

ISBN:

9780132737968

Author:

Thomas L. Floyd

Publisher:

PEARSON

C How to Program (8th Edition)

Computer Science

ISBN:

9780133976892

Author:

Paul J. Deitel, Harvey Deitel

Publisher:

PEARSON

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781337627900

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Programmable Logic Controllers

Computer Science

ISBN:

9780073373843

Author:

Frank D. Petruzella

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS