Create any one Database from the following topics in MS Access and take a screen shots on MS word with explanation and prepare a project
Libray Managment
Hotel Managment
Railway Reservation System
Table 1 - Book
Table 2- Student
Table 1 - Rooms
Table 2- Booking
Table 1 - Trains
Table 2- Passanger
Book_Id
Book_Name
Author_Name
Subject
Stu_Id
Book_Id
Stu_Name
Issue_Date
Return_Date
Room_No
Room_Type
Per_day_Charge
Cust_Id
Room_No
Cust_Name
No_of_days
Total_Amount
Train_No
Train_Name
Route
Pass_Id
Train_No
Journey_Date
General SQL Queries (Write the typed answers after making the project on last page)
Answers
Answer:
I will be there in the office today so I will not be able to make it to the meeting tonight but I will send you my resume for the position of a rough day and night with the letter from early today so I have to get my hands on your help and I will send you an invoice to you when I get to work early and the video of the letter and I will not be able to do it on the weekend so much
Explanation:
In order to be able to add and manipulate data, you first have to create a database. There’s not much to this. You’re creating just a container in which you will add tables. Creating a table is more involved and offers many choices. There are several types of tables from which to choose, some with unique features. When creating tables, you must also decide on the structure of each table: the number of columns, the type of data each column may hold, how the tables will be indexed, and several other factors. However, while you’re still learning, you can accept the default setting for most of the options when creating tables.
There are a few basic things to decide when creating a structure for your data:
- The number of tables to include in your database, as well as the table names
- For each table, the number of columns it should contain, as well as the column names
- For each column, what kind of data is to be stored