Podcast
Questions and Answers
Which data type is most appropriate for storing the 'Bus Number' in the BUS_DETAILS table?
Which data type is most appropriate for storing the 'Bus Number' in the BUS_DETAILS table?
- Int
- Boolean
- Date
- Varchar (correct)
What is the most likely purpose of the Uid field in the user_info table?
What is the most likely purpose of the Uid field in the user_info table?
- To store the user's username.
- To store the user's address.
- To store the user's age.
- To store a unique identifier for each user. (correct)
Based on the provided database design, which field in the BUS_DETAILS table would directly influence the price a customer pays for a ticket?
Based on the provided database design, which field in the BUS_DETAILS table would directly influence the price a customer pays for a ticket?
- Fare (correct)
- Bto
- Type
- Bfrom
In the user_info table, what is the significance of setting the NOT NULL constraint on multiple fields?
In the user_info table, what is the significance of setting the NOT NULL constraint on multiple fields?
Reviewing the SQL snippets, which action would an admin most likely perform using a query on the bus_details table?
Reviewing the SQL snippets, which action would an admin most likely perform using a query on the bus_details table?
Considering the front-end design of the 'Holiday Trip Support' system, what is the primary function of the 'Ticket Book' button?
Considering the front-end design of the 'Holiday Trip Support' system, what is the primary function of the 'Ticket Book' button?
In the context of the login page code, what is the purpose of the <input type="submit" .../> element?
In the context of the login page code, what is the purpose of the <input type="submit" .../> element?
Based on the UML diagram, which of the following actions can both an 'Admin' and a 'User' perform?
Based on the UML diagram, which of the following actions can both an 'Admin' and a 'User' perform?
In the provided CREATE TABLE statements, what is the purpose of the varchar data type?
In the provided CREATE TABLE statements, what is the purpose of the varchar data type?
Examine the index page coding. Which of the following elements is used to link an external stylesheet?
Examine the index page coding. Which of the following elements is used to link an external stylesheet?
Examine the database connectivity code. Which SQL statement is used to insert new data into a table?
Examine the database connectivity code. Which SQL statement is used to insert new data into a table?
In the CREATE TABLE user_info statement, which data type is assigned to the uid field?
In the CREATE TABLE user_info statement, which data type is assigned to the uid field?
Which HTML tag is used to define the title of the document, which is usually displayed in the browser's title bar or tab?
Which HTML tag is used to define the title of the document, which is usually displayed in the browser's title bar or tab?
Based on the database design for the USER TABLE, what field is used to store the user's email address?
Based on the database design for the USER TABLE, what field is used to store the user's email address?
Considering the BUS_DETAILS TABLE, which field would be most relevant when querying for all buses traveling to a specific destination?
Considering the BUS_DETAILS TABLE, which field would be most relevant when querying for all buses traveling to a specific destination?
Flashcards
Uid (User ID)
Uid (User ID)
A unique identifier for each user in the system.
Name (User's Name)
Name (User's Name)
The name associated with a user account.
Uname (Username)
Uname (Username)
The username chosen by the user for login purposes.
Age (User's Age)
Age (User's Age)
Signup and view all the flashcards
Adhar no (Aadhar ID)
Adhar no (Aadhar ID)
Signup and view all the flashcards
Pwd (Password)
Pwd (Password)
Signup and view all the flashcards
Email (User's Email)
Email (User's Email)
Signup and view all the flashcards
Bus_Id (Bus ID)
Bus_Id (Bus ID)
Signup and view all the flashcards
Bname (Bus Name)
Bname (Bus Name)
Signup and view all the flashcards
Bno (Bus Number)
Bno (Bus Number)
Signup and view all the flashcards
Bfrom (Bus Origin)
Bfrom (Bus Origin)
Signup and view all the flashcards
Bto (Bus Destination)
Bto (Bus Destination)
Signup and view all the flashcards
Time (Bus Timing)
Time (Bus Timing)
Signup and view all the flashcards
Type (Bus Type)
Type (Bus Type)
Signup and view all the flashcards
No_Seat (Number of Seats)
No_Seat (Number of Seats)
Signup and view all the flashcards
Study Notes
- The project is an online bus ticket booking system.
- It was submitted by Kishore P, an M.Sc. Computer Science student at Annamalai University.
- The project was guided by Dr. R. Ganapathiraja, an Assistant Professor/Programmer at Annamalai University.
Database Design: User Table
- The user table includes fields for UID, name, username, age, Aadhar number, password, and email.
- UID is an integer with a size of 11 and is the user's unique identifier.
- Name, username, age, Aadhar number, password, and email are stored as variable-length strings (Varchar) with a size of 30, except email, which is size 50.
Database Design: Bus Details Table
- The bus details table includes fields for bus ID, bus name, bus number, origin, destination, time, type, the number of seats, and fare.
- Bus ID, number of seats, and fare are integers with a size of 11.
- Bus name, origin, and destination are stored as variable-length strings (Varchar) with a size of 20.
- Bus number is stored as Varchar with a size of 20.
- Time and the type of bus are variable-length strings with a size of 10.
Sample Data for Users
- User 1: Kishore, username "kishore", age "25", Aadhar number "123456", email "[email protected]".
- User 2: Nishant, username "nishant", age "22", Aadhar number "12345", email "[email protected]".
- User 3: Rajeev Kumar, username "rajeev", age "23", Aadhar number "1234567", email "[email protected]".
Sample Data for Bus Details
- Bus ID 2: "Munnar Travels", bus number "mp 30 sc 0137", from Chennai to Kerala, departs at 6pm, AC bus, 80 seats, fare 1000.
- Bus ID 3: "Wayanadu Travels", bus number "MP07 Se1212", from Chennai to Kandaloor, departs at 7 pm, Non-AC bus, 80 seats, fare 500.
- Bus ID 4: "Chennai Express", bus number "up16sc1212", from Kerala to Chennai, departs at 6am, AC bus, 80 seats, fare 350.
- Bus ID 5: "Taj express", bus number "mp30Ka1213", from Bangalore to Ladakh, departs at 8AM, AC bus, 80 seats, fare 5000.
Front-End
- The front-end design features a landing page with the title "Holiday Trip Support."
- Prominently featured is the tagline "Making your Ride happen!"
- The landing page has buttons or links for "Home", "Admin", "login", and "Ticket Book".
Login Page
- The login page includes fields for username and password.
- Users can either log in or sign up.
UML Diagram: Actors and Use Cases
- Actors are Admin and User.
- Admin use cases: Manage routes, add routes, edit routes, delete routes, update password, update profile.
- User use cases: Search bus, login, register, update name, update email.
HTML Coding
- The index page includes:
- Title: Transport
- Linked stylesheet: css/style.css
- Email: [email protected]
- Contact Number: +91 9150805236
- Links: Admin, Login
<!DOCTYPE html>
<html>
<head>
<title>Transport</title>
<link rel="icon" type="image" href="img/logo.png">
<link href="css/style.css" rel="stylesheet">
</head>
<body id="body">
<i class="fa
fa-envelope-o"></i>[email protected]
<i class="fa fa-phone"></i> +91 9150805236
<nav>
<li><a href="registration/admin.php">Admin</a></li>
<li><a href="registration/login.php">login</a></li>
</nav>
</body>
</html>
Login Page Code
<html>
<head>
<body>
<h1> Log In User </h1>
<div class="form-group">
<input type="text" class="form-input" name="uname" id="name"
placeholder="Username" />
</div>
<div class="form-group">
<input type="text" class="form-input" name="psw" id="password"
placeholder="Password" />
</div>
<div class="form-group">
<input type="submit" name="login" id="submit" class="form-submit submit"
value="Log In" />
<a href="signup.php">Sign Up</a>
</div>
</form>
<script src="js/main.js"></script>
</body>
</html>
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
