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 three items contained in fat database

What does CHS stand for? List three items contained in the FAT database. List two features NTFS provides that FAT does not.

  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.

  Triggers important in database systems

What are triggers used for, and why are they important in database systems? Provide an example of a situation where a trigger would be appropriate.

  Create link list in adt to maintain employee information

Create a link list in ADT c to maintain employee information like name,empid,basic salary and address.1.add employee info to the list if the empid is valid.

  Create a function

Create a function that returns the day of the week for a specified date. Create a trigger that displays the message "Emp table updated" when an update to the employee table increases the employee's basic salary.

  Explain why data flow diagrams are developed in a hierarchy

Explain why data flow diagrams are developed in a hierarchy? What are the names of some levels in the hierarchy?

  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?

  Physical schema created for a database

At this point in the design process, you would have a detailed physical schema created for a database. How would you approach converting your schema into a database, complete with sample data? Explain your approach in two to three paragraphs.

  Write select statement that returns two columns

Write a SELECT statement that returns two columns: VendorName and PaymentSum, where PaymentSum is the sum of the PaymentTotal column.

  Determine a list of n numbers has no duplicates

Express given five loosely described problems carefully in { Instance, Question } form as utilized in "Computers and Intractability". Determine that a list of n numbers has no duplicates.

  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?

  Create a database from scratch

Create a database from scratch that contains, at a minimum, the elements listed below

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