Global Computer Solutions (GCS) is an information technology consulting company with many offices located throughout the United States. The company’s success is based on its ability to maximize its resources—that is, its ability to match highly skilled employees with projects according to region. To better manage its projects, GCS has contacted you to design a database so that GCS managers can keep track of their customers, employees, projects, project schedules, assignments, and invoices.

Global Computer Solutions (GCS) is an information technology consulting company with many offices located throughout the United States. The company’s success is based on its ability to maximize its resources—that is, its ability to match highly skilled employees with projects according to region. To better manage its projects, GCS has contacted you to design a database so that GCS managers can keep track of their customers, employees, projects, project schedules, assignments, and invoices.

Fundamentals of Information Systems

9th Edition

ISBN:9781337097536

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter8: System Acquisition And Development

Section: Chapter Questions

Problem 3PSE: A new sales ordering system needs a relational database that contains a customer table, a product...

See similar textbooks

Similar questions

You are one of the team members who your project team leader has assigned to involve in the discussion of developing an Automated Teller Machine (ATM) system. Throughout the discussion, you have gathered the following requirements statement for the ATM system from your clients' team members. The IT personnel from your client’s team need to understand the structure of your database and the interaction between the actor(s) or object(s) in the system. Therefore, you have instructed your System Analyst to provide the structural and behavioural modelling of the ATM system based on the requirements statement you gathered, as shown below : AutomatedTellerMachine The software to be designed will control a simulated Automated Teller Machine (ATM) having a magnetic stripe reader for reading an ATM card, a customer console (keyboard and display) for interaction with the customer, a slot for depositing envelopes, a dispenser for cash (in multiples of $20), a printer for printing customer…
Consider a database system for a Wholesale Management System. The data requirements are summarized as follows: o Maintain the details of stock like their id, name, quantity. o Maintain the details of buyers from which manager must buy the stock like buyer id, name, address, stock id to be bought. o Details of customers i.e. name, address, id. o Defaulters list of customers who have not paid their pending amount after the due date So List of payment paid or pending. o The stock that is to buy if quantity goes less than a particular amount. o Profit calculation for a month. o Quantity cannot be sold to a customer if the required amount is not present in stock and date of delivery should be maintained up to which stock can be provided. SQL Queries: 1. List of payment paid or pending customers. 2. Find the Defaulters list of customers who have not paid their pending amount. 3. Find the details of customers name, address, id. 4. Find Query to get information of employee where employee is…
What are the advantages of consolidating a patient’s medical records into a single database accessible by many? What are the risks associated with this consolidation?
Provide 2 examples why normal forms are being used in software engineering. Describe 2 consequences that are likely to occur if a relational database is built without normalizing the database. Share an example of these consequences using your own experience or from your readings.
Air-india want to create database to stores details about an airline’s fleet, flights, and seat bookings. Again, it’s a hugely simplified version of what a real airline would use, but the principles are the same. Draw an ER diagram based on the information given.Consider the following requirements list: • The airline has one or more airplanes.• An airplane has a model number, a unique registration number, and the capacity to take at most 100 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, and a unique email address.• A passenger can book at most 5 seats on a flight.[7](b) Convert the diagram 1(a) in relational model.
B.The Hudson Engineering Group (HEG) has contacted you to create a conceptual model whose application will meet the expected database requirements for the company's training program. The HEG administrator gives you the following description of the training group's operating environment. (Hint: Some of the following sentences identify the volume of data rather than cardinalities. Can you tell which ones?) The HEG has 12 instructors and can handle up to 30 trainees per class. HEG offers 5 Advanced Technology courses, each of which may generate several classes. If a class has fewer than 10 trainees, it will be canceled. Therefore, it is possible for a course not to generate any classes. Each class is taught by one instructor. Each instructor may teach up to 2 classes or may be assigned to do research only. Each trainee may take up to 2 classes per year. Given that information, do the following: Define all of the entities and relationships. (Use Table 4.4 as your guide.) Describe…
SYSTEMS DESIGN Robin Alper, a manager of the credit collections department for ACME Building Supplies, is extremely unhappy with a new system that was installed three months ago. Her complaint is that the data flows from the billing and accounts receivable departments are not occurring in the manner originally requested. Further, the updates to the database files are not occurring as frequently as she had envisioned. Thus, the hope that the new system would provide more current and timely information has not materialized. She claims that the systems analysts spent three days interviewing her and other workers. During that time, she and the other workers thought they had clearly conveyed their needs. She feels as if their needs were ignored and their time was wasted. Required What went wrong during the systems design process? What suggestions would you make for future projects? please explain in detail to better understand.
Explain how Excel can be used to design a database, including an example of a basic database layout that would be appropriate for, say, a gradebook for a graduating class’s overall GPA. Then, imagine that a business existed that used students’ information to propose specific colleges for them. What columns from the original spreadsheet would be kept? Propose at least four columns that would be added to a database for such a business, explaining how they would collectively help the business’s database function.
Based on the information given above, draw the conceptual EERD where you should include the enhanced features. You are required to design a database for a car championship. The requirements are as follows:In the championship, each car’s information such as the car model, the top speed and the acceleration will be stored, and it is identifiable through a unique car ID. Each car will be drove by only one driver. Each driver’s info such as the unique driver number, driver name and the experience level of the driver are stored as well. A driver may have many trainers from more experience drivers and these experience drivers would have at least one trainee who follow them. Each of these drivers are usually supported by a team which each team have a name and is identifiable through the team number. Usually, a team would have at least one driver in the race.Every race would have a specific race ID and a race name. In a race would consists of many cars and each race would have a record of the…
The drawbacks of file processing systems may also be limits of databases, according to the section "Disadvantages of File Processing Systems," which states this. To begin, why do companies have numerous databases when they might have a single database that could handle all of their data processing requirements? In other words, what are the organizational and individual variables at play that might cause a company to have several, separately maintained databases?
In general, there is consensus that database designs may include anywhere from two to three distinct levels, depending on the specifics of the system's needs. Are there any upsides to implementing a three-tier database structure? Discussbriefly