# data[].attributes.body
Train_Number
Train_Date
GeneralSeats_Number
ACSeats_Number
Booked-Generalseats_Number
Booked-ACSeats_Number

-Tapash

# data[].attributes.body
Ticket_Number
Passenger_ID
Purchase_Date
Destination_Address
Departure_Time
Arrival_Time
Ticket_Status

Pedro Hernandez

# data[].attributes.body
Ticket_Price
Ticket_Number
Departure_Time
Arrival_Time
Seat_Number
Travel_Time
Seats_Available
PK-Train_Number
TrainStation_Name
Station_Hours

Pedro Hernandez

# data[].attributes.body
Tried and still could not get through to edit anything...

# data[].attributes.body
SELECT Ticket_ID
FROM Passenger
IF EXISTS THEN DELETE Passenger;
IF Confirmed THEN SELECT Ticket_ID WITH Waiting_Status FOR Train_Number, Ticket_Category THEN UPDATE STATUS TO CONFIRM;

Kyle Hallquist

# data[].attributes.body
SELECT Train_Number,
Train_Date,
Ticket_Category FROM Passenger;

IF Ticket_Categeory=AC
THEN SELECT AC_SeatsNumber, AC_SeatsBooked,
FROM Train_Status;

IF Total AC_SeatsNumber > AC_SeatsBooked THEN INSERT Passenger;

IF General_SeatsNumber > General_SeatsBooked THEN INSERT Passenger;

Kyle Hallquist

# data[].attributes.body
Ticket_ID
Train_Number
Date_TicketBooked
Name
Age
Sex
Address
Reservation_Status
Ticket_Status(Confirmed,Waiting)
Ticket_Category

Kyle Hallquist

# data[].attributes.body
Train_Number
Train_Date
AC_SeatsNumber
General_SeatsNumber
AC_SeatsBooked
General_SeatsBooked

Kyle Hallquist

# data[].attributes.body
PK - Train_Number
Train_Name
Source
Destination
AC_TicketCost
General_TicketCost
Weekendays_TrainAvailable

Kyle Hallquist

# data[].attributes.body
Is it possible for one of us to just make another page and make it public and invite the group to it or the whole class? I was checking that just to see if it can be done. 

# data[].attributes.body
It won't let me change or add anything to the existing tables , which is a shame as they need to be configured ....  the tables / create option are locked.

Kyle

Kyle there isn't any restrictions set on this wall.  Are you able to go into a post and edit it?

I'm just going to Create my own tables and link them myself as it won't let me edit the other ones; All of my work will be below the other students work; Thanks , Kyle

# data[].attributes.body
Train_Number
Book_Date
Seat_Category
-Jessica

# data[].attributes.body
Ticket_ID
Book_Date
-Jessica

# data[].attributes.body
Business_Class
First_Class
Economy_Plus
Economy

Kevin Mejia

# data[].attributes.body
Tried to connect and add to the fields but it's locked. This can be deleted at anytime just wanted to let know.
-Brandon

# data[].attributes.body
PK - Ticket_ID
Train_Number
Book_Date
Passenger_Name
Passenger_Age
Passenger_Sex
Passenger_Address
Reservation_Status
Seat_Category

Trevor McGarrity

# data[].attributes.body
Train_Number
Train_Date
Total_AC_Seats
Total_GA_Seats
AC_Seats_Booked
GA_Seats_Booked

Trevor McGarrity

# data[].attributes.body
PK - Train_Number
Train_Name
Source
Destination
AC_Fair
GA_Fair
Availability
Ticket_ID

Trevor McGarrity

# data[].attributes.body
Use the create a post option by clicking anywhere on the screen or the pink + sign in the lower right hand corner.

Use the business rules listed in Case #12 to create the Entities for this Database.  In addition please add attributes (fields) that you think represent the Entity.

Everyone in the group should contribute to this activity. Please do not complete the entire diagram by yourself. Some where in your post include your name for grading purposes.