2- Design a system which keeps track of the jobs that it is performing an a company. • Each job is of a certain type, which is also identified by a type name. Each job performed is given a number, a starting date and a promised finishing data. The customer of a job is noted. • Any job of a given type is done in one or more steps, each of which is identified by a code and name. The steps are numbered as 1, 2, .... The average time to complete a step is also recorded. • It is possible for a given job step to be used in several types of jobs. When a job is accepted, the required steps to complete the job are scheduled and the estimated start and completion dates are recorded for each step. • What are the entities in this database and what are their attributes? What are the keys? What are the relationships and their attributes? Indicate both the cardinality and participation of each relationship. Draw an extended entity-relationship (EER) diagram for this database.

2- Design a system which keeps track of the jobs that it is performing an a company. • Each job is of a certain type, which is also identified by a type name. Each job performed is given a number, a starting date and a promised finishing data. The customer of a job is noted. • Any job of a given type is done in one or more steps, each of which is identified by a code and name. The steps are numbered as 1, 2, .... The average time to complete a step is also recorded. • It is possible for a given job step to be used in several types of jobs. When a job is accepted, the required steps to complete the job are scheduled and the estimated start and completion dates are recorded for each step. • What are the entities in this database and what are their attributes? What are the keys? What are the relationships and their attributes? Indicate both the cardinality and participation of each relationship. Draw an extended entity-relationship (EER) diagram for this database.

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

**Software Engineering class question:*** Describe the following design concepts: 1.Functional Independence Procedural Abstraction Copyright Data-Centered Architecture Sequence Diagram
General Computer Accessory Company: In General Computer Accessory Company (GCAC), each product (described by product number (primary key (PK)), description, and cost) comprises at least one component and can comprise many components (described by component number (PK), description, and unit of measure), and each component is used to make zero to many products. GCAC keeps track of the quantities of products and components in the manufacturing process. In addition, a component can be used to make zero to many other components and a component can consist of zero to many other components. GCAC also keeps track of how many components go into making some other components. Draw an ER diagram using Draw.io Links to an external site.and insert the diagram (as an image file exported from the drawing tool; ensure that the image is a clean ER diagram that does not contain non-relevant details such as tool background and buttons) in a file (enter your full name and assignment number on the first…
Activity 1. Please help me solve this engineering problem.
Report for Software engineering Component Scenarios : write at least 10 complete scenarios that cover all aspects of the target component. (( the component is employee management )) An example for register and log in component: Scenario 1: Register Customer Ali wants to register on the system. He entered his name, email and the phone number. System send a confirmation message to the Customer and the customer confirmed his email address. Scenario 2: Log In Customer Mohammed logged in to the System. During the login process internet connection was lost. System displayed an error message. I need it like this employee component for 10 scenarios for
Discrete structures
Make a use case diagram
DISCRETE STRUCTURE What is the minimum number of students, each of whom comes from one of the 13states, who must be enrolled in a university to guarantee that are at least100 comefrom the same state
state machine diagram for the following use case by draw io
1. First Class Mobile Shop, one of the leading mobile shops in Oman, offers various mobile gadgets for their loyal customers in various payment basis. Its manager wants you to make a simple program for them. Mobile Types included in the offer are phones and tablets, while Payment Schemes are Scheme A, Scheme B, and Scheme C. The program accepts Customer ID, Name, Mobile Type, Quantity, and Payment Scheme. Then, the program determines the Item Fee based on the given table below: Mobile Type Phone Tablet Scheme A 120 OMR 130 OMR Scheme B 150 OMR 180 OMR Scheme C 235 OMR 260 OMR Afterwards, the program computes the Payment Fee by multiplying the Item Fee with the Quantity. The program also computes the Registration Fee which is 4.5% of the Payment Fee. Then, it computes the Amount as the sum of Payment Fee and Registration Fee. Display all data. Write the program's pseudocode and draw its flowchart. 2. Samsung Sohar has assigned you to create a program that will enter the records of eight…
/*-
Real-time Scheduling: Select all of the following statements that are true. Soft real-time systems must guarantee that real-time tasks will be serviced in accord with their deadline requirements. A periodic task is a job that is repeated regularly. A real-time task's CPU utilization can be calculated by dividing its period length by its service time for one period. Schedulability refers to a property indicating whether a real-time system (a set of real-time tasks) can meet its deadlines. Real-time systems apply an admission-control algorithm in order to decide whether a task is admitted (guaranteeing that it will complete on time) or rejected (if it cannot guarantee that the task will be serviced by its deadline).
c program, Create a structure called car with the following members: • Make • Model • Year • Mileage