Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
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.
What does CHS stand for? List three items contained in the FAT database. List two features NTFS provides that FAT does not.
Suppose you have a table which contains 27,000 data records, and you have unclustered B+ Tree Index on the table.
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 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 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? What are the names of some levels in the hierarchy?
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?
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 a SELECT statement that returns two columns: VendorName and PaymentSum, where PaymentSum is the sum of the PaymentTotal column.
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.
Did the corresponding lines for invoices 1001 and 1008 in table LINE get deleted automatically? Can you explain why?
Create a database from scratch that contains, at a minimum, the elements listed below
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!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd