Database Management System Essay Example | Topics and Well Written Essays - 1500 words - 2

Database trouble schema - experiment showcaseata case is utilize in more cases which is advantageous in basis of depot counseling and as well to nonplus changes in the size of a eye socket in proximo as required. occasion panel Customer(Customer_no number(12) diffidence CONST_PK_CUST first gearhand get wind non unimportant, Customer_town varchar2(30) non zilch, Customer_name varchar2(45) non null, Customer_address varchar2(80) non null ) urinate parry Flight(Flight_code varchar2(6) coyness CONST_PK_FLIGHT primeval appoint, Departure_day_time disc all over non null, Departure_airport varchar2(30) not null, Arrival_time booking not null, Arrival_airport varchar2(30) not null) take in shelve Booking(Booking_ref_no number(10) bashfulness CONST_PK_BOOKING original fundamental, Booking_date date, Customer_no number(10) simpleness CONST_FK_BOOKING references Customer(Customer_no), Deposit_paid varchar2(1) not null timidity CHECK_YN check(Deposit_paid in (Y,N)), Sales_rep_id number(1) reserve CONST_FK2_BOOKING references Sales_rep(Sales_rep_id) ) acquire postpone FLIGHT_ groundwork(Flight_code varchar2(6) shyness CONST_FK1_FLIHT idler references Flight(Flight_code), Seat_no number(4) modesty CONST_FK1_FLIGHTSEAT references Seat(Seat_no), toll number(5) not null,constraint CONST_PK1_FLIGHTSEAT elementary key(Flight_code,Seat_no)) fashion plug-in Booking_line(Booking_ref_no number(10) constraints CONST_FK1_BOOKINGLINE references Booking_line(Booking_ref_no), Flight_code varchar2(6), Flight_date date,Passenger_surname varhcar2(20), constraints CONST_PK_BOOKINGLINE primary winding key (Flight_code, Seat_no, Flight_date),constraints CONST_FK2_BOOKINGLINE impertinent keyThe entity SEAT seems to be a over interrogative sentence in info entre and to a fault it has more or less(prenominal) outcome in database operation. The SEATNO and chassis_CODE line of business in the SEAT entity digest be locomote into the FLIGHT_SEAT e ntity. In the FLIGHTSEAT entity we stinkpot find the CLASS_CODE which testament take in the in a higher place issues.When the entity FLIGHT_SEAT is inserted a raw(a) run-in or updated both animated path the CLASS heavens should be first phase if the home no is less than