160 likes | 395 Views
Group Members: Ansa Gul Anuja A.Jahagirdar Amol Kakade Vineeth . Apogee Travels. Business Overview. Providing travel services for the customers since 2008. All transactions are currently conducted in the office. New System Create an online transaction medium
E N D
Group Members:Ansa GulAnuja A.Jahagirdar Amol KakadeVineeth Apogee Travels
Business Overview • Providing travel services for the customers since 2008. • All transactions are currently conducted in the office. New System • Create an online transaction medium • User friendly and a multi-user system • Expansion of business
DATA STORE • Customer Data • Employee Data • Login Details • Ticket Details • Travel Info Data
Physical Design • CUSTOMER( Cust_ID, Cust_Fname, Cust_Lname, Cust_Addr, Cust_Email, Cust_Phone) • LOGIN ( Login_ID, Cust_ID, Emp_ID, User_Name, Password) • EMPLOYEE ( Emp_ID,Emp_Fname,Emp_Lname,Emp_Addr, Emp_Email, Emp_Phone) • TICKET( Conf_Num, Ticket_Amt, Paypal_Conf) • TRAVEL_INFO( Info_ID,Conf_Num,Travel_Details) • CUST_TICKET( Cust_ID, Conf_Num)
Questions ?&Comments! • Thank you