The Super Coach Bus Company Sdn Bhd (SCBC) wants to develop a database to keep all information about its buses. Each bus bought by SCBC will be registered in the database. The information stored is bus plate number, model, year made, date of purchase and amount purchase. These buses are used to carry passenger from SNB bus station to many destinations all over Malaysia. Each bus may visit different destinations. Each destination can be visited by more than one bus. The information about destination includes destination code, destination name, and state. Once in a month, the buses need to be sent for maintenance to check for their conditions. The information about maintenance is maintenance identification, date sent for maintenance, date finish and the latest status of the bus condition. Every maintenance is performed by a mechanic. The information about mechanic that needed to be stored in the database is mechanic identification number and name. Other information about mechanic is qualification and years of experience. Based on the given information, draw an E-R diagram showing all entities, attributes, and relationships.

The Super Coach Bus Company Sdn Bhd (SCBC) wants to develop a database to keep all information about its buses. Each bus bought by SCBC will be registered in the database. The information stored is bus plate number, model, year made, date of purchase and amount purchase. These buses are used to carry passenger from SNB bus station to many destinations all over Malaysia. Each bus may visit different destinations. Each destination can be visited by more than one bus. The information about destination includes destination code, destination name, and state. Once in a month, the buses need to be sent for maintenance to check for their conditions. The information about maintenance is maintenance identification, date sent for maintenance, date finish and the latest status of the bus condition. Every maintenance is performed by a mechanic. The information about mechanic that needed to be stored in the database is mechanic identification number and name. Other information about mechanic is qualification and years of experience. Based on the given information, draw an E-R diagram showing all entities, attributes, and relationships.

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 11RQ

See similar textbooks

Similar questions

The city library of Batu Pahat has a database to keep track of its books, the people whoborrow books and who has borrowed which books. The tables with the data are includedbelow:• A table called BOOK, which contains data about the books. It has the attributesbook title, ISBN, number of book copies (which is used to separate different copiesof the same book), year of publication and author.• A table called BORROWER, which contains data about the persons who canborrow books. It has the attributes borrower id, borrower name, address, phonenumber, and the number of books that this person has borrowed at the moment.• A table called BORROW, where the borrow details are stored. It has the attributesbook title, number of book copies, borrower id, date (which is the date when thebook was borrowed), and borrower name.(For well-known reasons, there are very few books in the library.)Unfortunately, the design of the database is not very good. Your mission is to analyzethe problems by doing a…
Question-1 There are thousands of customers in an ABC Bank who use ATM services. The ABC Bank stores its ATM users’ data in a database table where records are sorted based on Account Numbers as below: ATM Card # Account # PIN Name Balance (Rs.) 11122230 Ac321 999 Ali 5,000 11122231 AC431 888 Hina 3,000 11122232 AC453 777 Saad 8,000 11122233 AC534 666 Fahad 9,000 when Fahad inserts his ATM card, he enters PIN and the main screen appears which shows his Name and other details. The authentication system searches the provided ATM Card # in database table. If ATM Card # is found, the system authenticates the user by matching the input PIN with stored PIN and returns Fahad’s profile data. So, From the given array of ATM Card numbers i.e. double A={11122230, 11122231, 11122232, 11122233, …} to find Fahad’s ATM Card # double target=11122233 Write the code for your chosen search either binary or linear search technique. The…
Question-1 There are thousands of customers in an ABC Bank who use ATM services. The ABC Bank stores its ATM users’ data in a database table where records are sorted based on Account Numbers as below: ATM Card # Account # PIN Name Balance (Rs.) 11122230 Ac321 999 Ali 5,000 11122231 AC431 888 Hina 3,000 11122232 AC453 777 Saad 8,000 11122233 AC534 666 Fahad 9,000 when Fahad inserts his ATM card, he enters PIN and the main screen appears which shows his Name and other details. The authentication system searches the provided ATM Card # in database table. If ATM Card # is found, the system authenticates the user by matching the input PIN with stored PIN and returns Fahad’s profile data. So, From the given array of ATM Card numbers i.e. double A={11122230, 11122231, 11122232, 11122233, …} to find Fahad’s ATM Card # double target=11122233 Write the code for your chosen search either binary or linear search technique. The…
In the real world, what components are essential for the creation of a database? Create a list of the messaging services that are used by the largest number of people. In the event that this is the case, do they adhere to the same restrictions as SMS?
You are asked to check a potential data bridge problem. What are the steps you will follow in order to check the database? and fix any problems with it. Have in mind you SHOULD normalize it as well.(1500 words Minimum)
An unusual problem has occurred for a small multinational company: People are getting confused about dates in internal memos, purchase orders, and email. When the company’s database was originally designed, the designer was not aware that the format for dates in Canada and Mexico was different from the format used in the United States. For example, in Canada and Mexico, the notation 7/1/19 indicates January 7, 2019, whereas in the United States the same notation indicates July 1, 2019. Although it seems like a small point, the date confusion has resulted in several order cancellations. How would you fix this issue in the database?
What is the best way to analyze database indexes so that they run in an optimal fashion? Provide examples to support your analysis.

Recommended textbooks for you

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Fundamentals of Information Systems

Computer Science

ISBN:

9781305082168

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:

9781337097536

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Principles of Information Systems (MindTap Course…

Computer Science

ISBN:

9781305971776

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Principles of Information Systems (MindTap Course…

Computer Science

ISBN:

9781285867168

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Fundamentals of Information Systems

Computer Science

ISBN:

9781305082168

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:

9781337097536

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Principles of Information Systems (MindTap Course…

Computer Science

ISBN:

9781305971776

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Principles of Information Systems (MindTap Course…

Computer Science