Define a data flow in bus information system

Assignment Help Database Management System
Reference no: EM1358908

City Bus Lines Situation: City Bus Lines is developing an information system that will monitor passenger traffic, peak travel hours, and equipment requirements. The IT manager wants you to document a process called BALANCE that determines whether extra buses currently are needed on a particular route. The BALANCE process automatically assigns additional buses to that route, but only if all other routes are operating on schedule. In any case, a supervisor can override the automatic BALANCE process if he or she so desires.

a. Create a decision table that describes the bus transfer process.

b. Draw a decision tree that describes the bus transfer process.

c. Name four attributes that you can use to define a data flow in the bus information system.

d. Name four attributes that you can use to define a data store in the bus information system.

Reference no: EM1358908

Questions Cloud

Theory of cognitive functioning : Explain how the results of "The Nun Study" are substantiated by the "Use It or Lose It" theory of cognitive functioning.
Managing teams : Overall performance of the team and make two recommendations for how that impact could be mitigated. Provide specific examples to support your response.
Effort to manage effectively their older employees : Explain what strategies can managers implement in an effort to manage effectively their older employees? Lastly, can employing older workers provide a competitive advantage?
Compares and contrasts aspects of quattro pro : As a result of your work on the high school reunion project, you decide to learn more about Excel and the many uses of spreadsheet applications. You know that there are other spreadsheet applications on the market,
Define a data flow in bus information system : Name four attributes that you can use to define a data flow in the bus information system. Name four attributes that you can use to define a data store in the bus information system.
Explain how would you show this with a simple supply : Explain how would you show this with a simple supply and demand diagram. If this firm was monopolistically competitive with a "u-shaped" cost structure, how would you show the results of this firm's attempt to increase its profits.
Comprehensive annual financial report briefing : Prepare an overview of government accounting for a business person, using the State of Georgia as an example. Describe the entity and evaluate the Management Discussion & Analysis (MD&A) section.
What is the speed of the large cart after the collision : What is the speed of the large cart after the collision. A 345 g chunk of gold at 98.5 degrees Celsius is dropped into a 656 g of water at 22.5 degrees Celsius. What will final temperature of the gold be after the system reaches equilibrium.
Compute the stock price : Toyota has decided to offer new preferred stock for sale that it will call an 8-8 offering. This stock will pay an yearly dividend of $8 a share starting eight years from now.

Reviews

Write a Review

Database Management System Questions & Answers

  Write program that models an employee

Write a program that models an employee. An employee has an employee number, a name, an address, and a hire date. A name consists of a first name and a last name.

  Explaining unclustered b pus tree index

Suppose you have a table which contains 27,000 data records, and you have unclustered B+ Tree Index on the table.

  Types of relationships in a design model of a database

There are many kinds of relationships in a design model of a database. Why is it important to classify each of these types in an ERD Model?

  Determine functional dependencies of table

Using your knowledge of Premiere Products, determine the functional dependencies that exist in the following table.

  Database to keep track of auto sales in car dealership

CAR (Serial-No, ModConsider the given relations for database which keeps track of auto sales in car dealership.

  Indicate change to make original premiere products database

Indicate the changes (using the shorthand representation) that you would need to make to the original premiere products database desing to support the following requirements.

  Baxter aviation database

ER diagram for the Baxter Aviation database

  An active database in pl-sql

Did the corresponding lines for invoices 1001 and 1008 in table LINE get deleted automatically? Can you explain why?

  Find average number of books borrowed per member

Find the average number of books borrowed per member. Take into account that if a member does not borrow any books, then that member does not appear in the borrowed relation at all.

  Evaluate the success wellco and pharmacare shareholders

Evaluate the success WellCo and PharmaCARE shareholders

  Write names-e-mail addresses for all customers from table

Show all the data in each of the four tables. Do not show foreign key columns. Write names and e-mail addresses for all customers who have had a stove repair that cost more than $50.

  Writing down sql query

Write down the SQL code in order to carrying out the following requests. Display all the data in each of the four tables. Do not display the foreign key columns.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd