Q1- A project consists of 11 activities, represented by the network shown below, and also the durations required to perform various activities of the project are given in the network. (a) Create a table that includes the activities, predecessors and duration in days. (b) Compute total float. (c) Determine the critical path. D 12 K (5 10 12 8 H J. 6. 6.

Q1- A project consists of 11 activities, represented by the network shown below, and also the durations required to perform various activities of the project are given in the network. (a) Create a table that includes the activities, predecessors and duration in days. (b) Compute total float. (c) Determine the critical path. D 12 K (5 10 12 8 H J. 6. 6.

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

Q3: A national bank and an international bank decide to merge. Assume, that both the organizations use almost similar ER diagrams. Prepare the ER diagram for the merged bank. Make, and state, suitable assumptions if any. Q4: A construction company has many branches spread all over the country. The company has two types of constructions to offer : Housing and Commercial. The housing company provides low income housing, medium style housing and high end housing schemes, while on the commercial side it offers multiplexes and shopping zones. The customers of the company may be individuals or corporate clients. Draw the ER diagram for the company showing generalization or specialization hierarchies and aggregations, if any. Also create 3NF tables of your design.
Q3: Consider the following project activities with a normal unit: (The normal unit is Day) Activity Name Immediate Predecessor (list number/ name, separated by ‘,’) Normal Time A 6 B A 2 C A 4 D B, C 3 E D 1 F D 7 G E 4 H F, G 2 I F 6 J I 1 K H, J 5 Fill the following table: (Attached)
4. Company TeaLeaves has recently adopted a new order management system for handling production requests. The sales representative can place a new order for production. If special materials are required for producing the new order, then an order is placed for special materials with the supplier. Otherwise, if no special materials are required for producing the new order or the supplier has finished providing the special materials, the order is added to the production list. Afterwards, the order is scheduled for production. Once the order is confirmed, a letter is generated to the sales representation and to the manager. Draw the activity diagram for the above scenario.
Draw the ER diagram of the following requirements: A City Hall wants to manage the members of its entertainment centers. Each center has an address, a district, a unique name. Each center offers several animations. An animation is provided by only one center. Each animation has a unique name and semi-annual cost. A member has a unique id, name (first, middle, last), several contact phone numbers and an address. A member may enroll only in one center and the date of registration is maintained. The member can practice many animation activities.
A warehouse is where the company stores its products and the storage bins in the warehouse are specified identified to their aisle, location in the aisle, and its shelf. There are a total of 40 aisles, 64 horizontal locations in each aisle, and 6 shelves. What is the least number of products the company can have so that at least two products must be stored in the same bin?
Draw the EER diagrams for the following problems using UML notation, Crow’s Foot notation and Chen notation: A large organization has several parking lots, which are used by staff. Each parking lot has a unique name, location, capacity, and number of floors. Each parking lot has parking spaces, which are uniquely identified using a space number. Members of staff can request the use of a parking space. Each member of staff has a unique number, name, telephone extension number, and vehicle registration number. The majority parking spaces are under cover and can be allocated for use by a member of staff for a monthly rate. Parking spaces that are not under cover are free to use when available. Up to twenty covered parking spaces are available for use by visitors to the company. However, only members of staff are able to book out a space for the day of the visit. There is no charge for this type of booking, but the member of staff must provide the visitor’s vehicle license number.…
uml sheet question 2: Design UML diagram for the license issuing process of vehicles. Therequirements are as follows:o The country is divided into departments (Cairo, Giza, Alex….etc.). Each department is described by a code (unique), and severalservice locations (e.g., for Cairo department, there are: Heliopolis,Nasr City etc.).o Each Vehicle is described by a number (unique: for all vehicles inthe same department), model, type (private, Limousine, taxi….etc.), color, motor capacity, number of seats, manufacturing year,license issue date, license expiry date, owner, tax rate, and a set offins. The owner, type, and tax rate information are mandatory foreach vehicle. Each vehicle type is identified by a code (unique),name (unique), and has a set of tax categories. Each tax categoryhas a specific tax rate.o Each vehicle fin is described by number (unique), type, date, andvehicleo Each fin type is associated with specific value. When a vehicle istransferred from one department to another…
A.1 Q is a local governmental organization (council) for a town in country U. It has a large call center to deal with queries and complaints from local residents and aims to ‘help callers find the information they need. Callers are asked to grade their satisfaction levels from 1 to 10 once they have completed their call, depending on how satisfied they were with their service. Currently, the higher the average grades given by callers across the year, the higher the bonus given to call center staff. The call center experiences a high volume of calls, with a number of calls going unanswered. Q has recently decided to change the performance mix for its call center staff. Staff will now be assessed on three separate measures: the number of calls taken by the center in the period, the average speed with which the call is handled and the total number of complaints about call center service received by Q. Each of these three measures will contribute equally to call center staff bonuses. Based…
Luxury-Oriented Scenic Tours (LOST) provides guided tours to groups of visitors to the Washington, D.C. area. In recent years, LOST has grown quickly and is having difficulty keeping up with all of the various information needs of the company. The company's operations are as follows: LOST offers many different tours. For each tour, the tour name, approximate length (in hours), and fee charged is needed. Guides are identified by an employee ID, but the system should also record a guide's name, home address, and date of hire. Guides take a test to be qualified to lead specific tours. It is important to know which guides are qualified to lead which tours and the date that they completed the qualification test for each tour. A guide may be qualified to lead many different tours. A tour can have many different qualified guides. New guides may or may not be qualified to lead any tours, just as a new tour may or may not have any qualified guides. Every tour must be designed to visit at least…
Sun and Earth (S&E) is a company set up to conduct geological explorations of parcels of land in order to ascertain whether significant metal deposits (worthy of further commercial exploitation) are present or not. Current (S&E) has an option to purchase outright a parcel of land for £3m. If (S&E) purchases this parcel of land then it will conduct a geological exploration of the land. Past experience indicates that for the type of parcel of land under consideration geological explorations cost approximately £1m and yield significant metal deposits as follows: manganese 1% chance gold 0.05% chance silver 0.2% chance Only one of these three metals is ever found (if at all), i.e. there is no chance of finding two or more of these metals and no chance of finding any other metal. If manganese is found then the parcel of land can be sold for £30m, if gold is found then the parcel of land can be sold for £250m and if silver is found the parcel of land can be sold for £150m.…
Sur University Registration - System Scenario: Sur university Registration department (SRD) wants to develop Sur University Registration System (SUReg S), in order to automate the registrations processes, The (SUReg_ S) existing system can be described as follows, the systems stores the following data for faculty_Members ( staff_No, staff_name, dep), for students store the following data (stu_ID, Stu_Name, Stu Address), for (SRD)'s employee saving the following data: (emp_No, job). The (SRD) focusing on the following activities, register courses for students, Entering students marks, calculate total marks, process the result. Calculating the student's total marks, requires checking two important issues firstly check that the student has registered in the required semester, as well as student's absent ratio is less than 20% in all courses. Finally (RAD) announced the students result for a semester or two semesters. Answer the following questions: [Based on the above scenario] A- Create…
Consider the following Scenario the Modeling of which you have completed in Assignment1: The Ministry of XYZ is the government body in the in charge of religious affairs. The application for Hajj is submitted to the hajj directorate, part of XYZ Ministry. Initial documents are submitted to the hajj directorate for registration. Documents are checked and verified by the Assistant Registration Officer. There are two categories of applicants based on their nationality. Specified percentage of seats are fixed for locals and other nationals. A unique registration number is issued to each applicant by the Assistant Registration Officer. After the completion of registration process, each applicant is asked to submit the detailed documentation which includes passport, vaccination certificate, medical certificate, receipts of payments. One Additional document (permission letter from home country) is needed for other national. Payments can be made through cash or card. Assistant Registration…