Concept explainers
Explanation of Solution
a.
Using excel or Access import the word data into a work file and compute the total labor for each type of employee for each meeting:
The work file and total labor for each type of...
Explanation of Solution
b.
Using the file created in part a, compute the total labor for each type of employee for each phase of the project:
The file created in part a represents the work file for each type of employee for each meeting...
Explanation of Solution
c.
Compute the total cost of meetings in each phase of project by combining data in part b and the excel file:
The file created in part b represents the total labour for each type of employee for each type of project...
Explanation of Solution
d.
Use a graphic chart to show the differences between meeting cost and budget:
A graphic chart to show the differences between me...
Explanation of Solution
e.
Comments whether excel or access would be the best choice to solve this problem:
- Excel is more appropriate for this type of problems as it is more suitable for calculation oriented situations as present in this problem...
Want to see the full answer?
Check out a sample textbook solutionChapter AE Solutions
Using MIS (10th Edition)
- For this week's assignment you will allow the user to add employee, view all employees, search employee by ssn, and edit employee information. Below this is what its supposed to look like when completed. I have also included what I started to do but I can't figure out how to add the search by SSN option or the edit employee option. If you can give me a step by step on how to do this in python I would greatly appreciate it.arrow_forwardA company has a number of employees. Each employee is identified by an Emplyee_Id. The companywants to store Employee_Name, Employee_Address, and Employee_BirthDate in the database. Thecompany also has several projects. Each project is identified by a Project_Id. The company wants tostore Project_Name and Project_StartDate in the database. Each employee must be assigned to one ormore projects, or may not be assigned to a project. A project must have at least one employee assignedand may have any number of employees assigned. An employee’s billing rate may vary by project, andthe company wishes to record the applicable billing rate (Billing_Rate) for each employee when assignedto a particular project. Draw an entity relationship diagram (ERD) using crows foot notation for the following situation. Show visible analyst.arrow_forwardCreate a set of use cases for the accompanying dentist office system, but do not bother to identify the steps within each use case. (Just complete the information at the top of the use case form.) When new patients are seen for the first time, they complete a patient information form that asks for their name, address, phone number, and brief medical history, which are stored in the patient information file. When a patient calls to schedule a new appointment or change an existing appointment, the receptionist checks the appointment file for an available time. Once a good time is found for the patient, the appointment is scheduled. If the patient is a new patient, an incomplete entry is made in the patient file; the full information will be collected when the patient arrives for the appointment. Because appointments are often made far in advance, the receptionist usually mails a reminder postcard to each patient 2 weeks before the appointment.Draw a level 0 DFD for the above dentist…arrow_forward
- The distinction between edit, brief, and update runarrow_forwardGiven the schema below: Developer(DevCode, DevName, DevAddr, DevEmail, DevTel) Proj(ProjCode, ProjTitlee, BeginDate, EndDate) SW(SWCode, SWName, SWPrice, ProjCode) Task(DevCode, ProjCode) Create a view that contains all projects and the SW developped within the project grouped by project. Write a PL / SQL block to display the details of projects which have software having a price more than 100. This block should display ProjCode, ProjTitleName, SWTitle and SWPrice.arrow_forwardCan you tell the difference between data definition commands, data manipulation commands, and data control commands, and when to use each one?arrow_forward
- The International Conference on Mathematical Sciences and Technology, MathTech, is a biennial conference organised by the School of Mathematical Sciences, USM. This event is open to all national and international experts, practitioners, researchers, and academics to gather and share their knowledge. The details of fees for participation in the conference are shown in the following table. Category Local (RM) International (USD) Presenter 990 260 Observer 150 Note: 1 USD = RM4.20 Assignment Requirement Part 1: Create Invoice Construct a C++ program to do the following tasks: a. Enter the participant's name, category, nationality, accommodation (Yes/No). b. If the answer for the question on accommodation is Yes, the program will ask for the number of days. Then the program will call function calcAccommodation () to calculate the accommodation charges. calcAccommodation() receives accommodation (Yes/No), number of days and participation type (local/international) as parameters and return…arrow_forwardProblem Statement: You are the CTO of a startup based out of Arlington, VA that needs to setup a database to keep track of the details of the customers: last name, first name, customer ID, street address, customer star rating (a rating on a 1– 5 scale, with 5 being best, representing the type of customer) and phone number. It also needs to keep track ofsimilar information for suppliers as well (although instead of supplier first and last name, there will just be a suppliercompany name). The database should maintain the data on products that are offered. Information about whichproduct is offered by which supplier should also be maintained. Finally, which customers have purchased whichproducts should also be tracked (note that we are only interested in which customers bought which product, but notconcerned about the date or how many were bought). 1.1 Business Rules: Assumptions for the business model are as follows:•Only customers that have purchased one or more products will exist in…arrow_forwardCreate the database name Company which consists of one Entity name Employee which consists of 10 attributes (ID/First Name/Last Name/CNIC/Gender/Department/Salary/Address/Age) ID should be primary key Insert at least 10 records in the Entity Employee with respect to their type. Implementation the example of stored procedure now creates the stored procedure which: Have an ability to insert the record in the table. Have an ability to delete the record in table. Have an ability to update the record in the table. Have an ability to display the record in the table.arrow_forward
- You are contracted to complete the data system for Citywide Taxi Company. Now, the information for each taxi is expanded to include: taxi id (such as CTC0001), the driver’s name, the maker of the Car (such as Ford), the model of the car (such as Escape), the Color of the Car (such as Black), the license number (such as HXT 4578), the number of passages the car served in the entire shift (integer type, this field will be left empty for this project). Your C++ program will (with array of class object): Define a class for the car with all members of variable mentioned above as private; Write all necessary class member functions to access those member variables (write or read); Read up to 50 records of data from the keyboard (provide a method to end the input before reaching 50 records) Save all records inputted from step 3 to a disk file called CTC.dat.arrow_forwardThis is a simple list table of a company trying to keep track of employee assignment to company protects (In other words, not a database but a flat one table file). You will design a database for this company so that they won't be retying on a simple I table list system to keep track of their data Looking at the table below, produce the 3Nf of the data Normalize to the first three normal forms Project Project Project Project Employee Employee Department Department Hourly Manager Budget Name Reservation Mr. Ajay System Reservation Mr. Ajay System Reservation Mr. Ajay System HR System HR System HR System Code Budget No. 120500 S100 Name No. Name Rate PC010 Mohan D03 Database 21.00 PC010 120500 S101 Vipul D02 Testing 16.50 PC010 120500 S102 Riyaz D01 IT 22.00 500500 S103 500500 S104 500500 S315 710700 S137 PC011 Mrs. Charu Pavan D03 Database 18.50 Jitendra Pooja PC011 Mrs. Charu D02 Testing 17.00 PC011 Mrs. Charu D01 IT 23.50 PC012 Attendance Mr. Rajesh Rahul D03 Database 21.50 System…arrow_forwardCreate a login screen description document for this system that contains at least eight basic fields. Create a file table for this system that contains at least ten basic fields that is part of the database design. (Note the document and schedule for the restaurant program). Another note the checkboxes the table consists of ( field/format/ null / primary key/ unique/ check / default/ f.k / reference/ join condition / index )arrow_forward
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningNp Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage