Question

Question 1: A transportation company which provides the management of the bus service in a city gets help from group of volunteers who sent pictures of people crossing the streets, kids playing in the street, angry people waiting on a bus stop, words “be happy”, timetable of the train service to next city and the length of the bridge via which main transportations of the city goes. Can the company use all of the above-mentioned contributions to build data base for management of the bus service? Discuss completely why yes or why no.

Question 2: A CIO of organization XYZ made the following statement: “Our IT department must be able to work effectively with increasing information volumes because information leads to data and data leads to knowledge”. Comment on CIO’s statement.  

Question 3: The following information for University database is available:

• Professors have SSN, name, family name and department.
• Each project is managed by one professor (PI)
• Each project can be managed by more than one professor (CoPi)
• Each student is identified by his/her SSN, age, name and family name and his/her GPA
• Each student can participate in 1 or 2 projects.

Write full ER diagram for this information. Discuss is it possible to cluster ER or is it not possible (answer why? Question in both cases). In both cases provide full reasoning.

Write clustered ER if you decided it is possible.

Question 4: Given the following relation:

SID	Name	Age	GPA	login
1235646	Smith	21	3.0	Smith27
6545765	Jonas	19	4.0	Jnm12
7688123	Koen	20	3.3	Bbn2
7682347	Kim	21	3.8	Km3

Which attributes or attribute you can deduce are not/is not a candidate key, based on this instance being legal. Provide your reasoning.

Answer 1

Answer 1:

A transportation company which provides the management of the bus service in a city gets help from group of volunteers who sent pictures of people crossing the streets, kids playing in the street, angry people waiting on a bus stop, words “be happy”, timetable of the train service to next city and the length of the bridge via which main transportations of the city goes.

Yes, the company can use all of the above-mentioned contributions to build data base for management of the bus service because of the following reason as

· Pictures of people crossing the streets – This picture will be help for the drivers and drivers can get the initial learning for the crowded and target locations where they will get likely more people crossing the road. Thus this is useful information

· Kids playing in the street – This is also important form the safety point of view for the driver. Hence this information should be captured in the database.

· Angry people waiting on a bus stop – This information is also helpful in managing the angry people waiting at the bus stop so that bus team can manage with the angry people adequately and make them calm.

· Words “be happy” – This is the right word which need to be used by the driver and bus team and need to push to all passengers so that their mental stage will be better.

· Timetable of the train service to next city – This will help the bus to improve their services to align with respect to the target trains which are required to be catch by the passengers. Thus vital information for more customers for the bus service and improve the profitability and turn over for the business.

· Length of the bridge via which main transportations of the city goes – This is also important for the drive point for view as it may impact the timeline of the bus service as high crowd can be seen on the bridge and drove can plan and manage the bus rive accordingly.

Answer 2:

A CIO of organization XYZ made the following statement: “Our IT department must be able to work effectively with increasing information volumes because information leads to data and data leads to knowledge”. This is the right statement of the CIO, because the information is the vital thing that helps the entire business and it forms the basis for as the growth and success of the business, as the information is captured by the system and it turns it into meaningful data for the business. The meaningful data will help to convert into knowledge for the business. This knowledge will be utilized and used by the business employee in future and will helping in growing and promoting the business to achieve their future business targets.