Databases | SQL | Oracle | MS Access Answers

Assume you have been contracted to develop a database system for the University library, you are required to use a systems development life cycle approach to discuss how you are going to approach the project. Discuss the various user groups that will be involved during the requirements analysis. What are the key issues that need to be answered

Assume you have been contracted to develop a database system for the University library, you are required to use a systems development life cycle approach the project, discuss how you are going to approach the project

#Write SQL query for Railway Management System

The Main aim of the Railway

Management Mini DBMS project is

to ease the process of railway

reservation. We aim to

demonstrate the use of create,

read, update and delete MySQL

operations through this project. In

this project, we first add the details

of trains and their halting stations.

Then passengers can book a ticket

by adding their details, source and

Destination. Passenger module

shows the number of passengers

boarding to the station. Trains and

Stations can be added or deleted

and the train details can be

updated for changing the timing on

arrival and departure or just

increasing or decreasing the

amount for tickets based on

classes such as 2A,3B,etc.

1) Indicate at least two different meanings for each of the following sentences, by including names for object types and reference modes.

1.   Arnold can lift 300.

Write a statement to create a stored procedure named Find_Contact based on the Contacts table in question 1 A, which does the following:Accepts an input parameter named @FindMobile that has the data type varchar. IF MobileNo exists: Print the message “Mobile No for:” concatenated with the input parameter. IF MobileNo do not exists: Print the message “Do Not Exist” concatenated with the input parameter. Executes a SELECT statement on the table Contacts, passing the input parameter as part of the WHERE clause. Return the contact details that match the input parameter value.

Write a procedure and call it into main pl/sql program to find a factorial of a number.

Write a procedure to calculate factorial of a number entered by user.

Given relation R (A,B,C,D) and the following FD’s. Identify the candidate key for R and highest normal form

B->C, D->A

Find the Super Keys : R(ABCDE)

FDs : AB -> C, C->D, B->E