normalization assignment FOR ANT and AST

normalization assignment FOR ANT and AST - DDM...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
DDM Normalization Assignment 1. Consider the following fields and design files upto 3 rd NF TrainNo TicketNo/PRNo TrainName Status: Confirm / Waiting /Cancelled JourneyDate DateOfBooking RailwayRegion NameOfThePerson Class Address StationFrom TelephoneNo StationTo NameOfTheChildrenWhoAreUnderAgeOfFive BoardingAt ReservationCharges TotalNoOfSeat(s)/Berth(s) AmountOfTheTicket Sr.No(s) TotalAmount Name(s) OfThePassenger SexOfThePassenger AgeOfThePassenger Remarks if any (Doctor, Senior Citizen, Handicapped)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Normalize the following document upto 3 NF: TELEPHONE BILL Category No: _____________________ Class Individual / Commercial _______________ Category : _____________________ Name : _____________________ Address : _____________________ _____________________ Telephone No : ___________________ Bill No. _______________ Bill Date:___________ Due Date:__________ Prev Reading Pres Reading Metered Calls Debit Calls Credit Calls Free Calls Net Chargeable Calls Call Charges _____________ Rent
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 07/15/2011 for the course ECO 2023 taught by Professor Mr.raza during the Summer '10 term at FAU.

Page1 / 4

normalization assignment FOR ANT and AST - DDM...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online