Chapter 3. System Structure

1. Basic Control--include Picture, Text box, Label, Frame, Command Button, Option Button, Check Box, List Box, Combo Box, Scroll Bar, Timer, Drive List Box, Directory List Box, File List Box, Shape, Line, and Data Control, which are the fundamental components of windows.
2. Animaton.vbx-- is a flexible button control that allows you to use any icon, bitmap, or metafile to define your own button controls. Control types include animated buttons, multistate buttons, and animated check boxes.
3. Cmdialog.vbx--provide a standard set of dialog boxes for operations such as opening, saving, and printing files or selecting colors and fonts.
4. Crystal.vbx--provide the ability of print. It services as the bridge between application and printer.
5. Gauge.vbx--create user-defined gauges with a choice of linear (filled) or needle styles
6. Graph.vbx--allow you to design graphs interactively on your forms. At run time, you can send new data to the graphs and draw them, print them, copy them onto the Clipboard, or change their styles and shapes.
7. Grid.vbx--display a series of rows and columns. The intersection of a row and column is a cell. You can read and set the contents of each cell programmatically.
8. Keystat.vbx--display or modify the CAPS LOCK, NUM LOCK, INS and SCROLL LOCK keyboard states.
9. Mci.vbx--manage the recording and playback of multimedia files on Media Control Interface (MCI) devices. Conceptually, this control is a set of push buttons that issues MCI commands to devices such as audio boards, MIDI sequencers, CD-ROM drives, audio CD players, videodisc players, and videotape recorders and players. The MCI control also supports the playback of Video for Windows (*.AVI) files.
10. Mscomm.vbx--provide serial communications for your application by allowing the transmission and reception of data through a serial port.
11. Msmapi.vbx--perform a variety of messaging system functions after a messaging session is established with the MAPI session control. The MAPI messages control is shown here, as it appears as an icon in the Toolbox, and on a form at design time.
12. Msmasked.vbx--provide restricted data input as well as formatted data output. This control supplies visual cues about the type of data being entered or displayed
13. Msole2.vbx--is a technology that allows a programmer of Windows-based applications to create an application that can display data from many different applications, and allows the user to edit that data from within the application in which it was created. In some cases, the user can even edit the data from within the Visual Basic application.
14. Msoutlin.vbx--is a special type of list box that allows you to display items in a list hierarchically. This is useful for showing directories and files in a file system, which is the technique used by the Windows File Manager.
15. Picclip.vbx--allow you to select an area of a source bitmap and then display the image of that area in a form or picture box. Picture clip controls are invisible at run time.
16. Spin.vbx-- use with another control to increment and decrement numbers. You can also use it to scroll back and forth through a range of values or a list of items
17. Threed.vbx--is a push button that turns its state on and off when clicked. Individual 3D group push buttons can be used in groups to emulate the functionality of the tool bar in Microsoft Excel spreadsheets or the ribbon in Microsoft Word for Windows word processing program.

Figure 3-1. Custom Controls

3.1 System Structure

1. Setup program: This function takes care of the installation of program that creates the directory of system and copies all files which are required for this program into the appropriate places.
2. Login function: It classifies the user priority that means what kind of user has what kind of right in operating this program.
3. Main Screen: It acts as the main interface which controls the whole procedure in this program, including Create Travel Resource, Introduce Travel Plan, Customer Register, Build Travel Plan, Map, Users Administration, Users Information, Add or Edit User, Report, Customer Search, Hotel Search, Demo Setup, Travel Plan Demo, Air Lines Search, and On-line Help.

3.2 DataBase Structure

3.2.1 Normalization

Figure 3-4 Functional Dependency of Customer

Figure 3.5. Air Lines Data Structure

Figure 3.6 Hotel Data Structure

3.2.2 Normalized Base Tables

1. Travel Plans Table--record the information about the travel plan.
   Primary key: PlanNum.
   Foreign key: TravelName.
   

   PlanNum						TravelName	BegDate	EndDate	Cost	Description
   1						Hoston	1994-11-10	1994-12-12	450	This trip is to go to Houston

2. Travel Plan Spots Table--record the spots, hotel, and air line information for each travel plan.
   Primary key: Date.
   Foreign key: SpotName, Hotel, FlightCompany, FlightNumber.
   

   Date						SpotName	Hotel	Memo	Hotel Name	Flight Company	Flight Number	Time
   1						Houston Museum	1	To visit the Art	Holiday Inn	NW	101	0530p

3. Spot Resource Table--record the resource, like movie, and map file names for each spot.
   Primary key: SpotName.
   

   SpotName					Movie	Map	Description	Country
   Houston Museum					watrfall.avi	antarcti.bmp	To see the Great Art gallery.	USA

4. Customer Registration Information For specific Travel Plan Table--record the customer register information.
   Primary key: FirstName, LastName, MidName.
   

   FirstName						LastName	MidName	OrderDate	Balance	Memo
   TangHsiu						Liao		1994-02-02	300	for normal price

5. All Customer Information Table--store all customer information.
   Primary key: FirstName, LastName, MidName.
   

   FirstName										LastName	MidName	Phone	Address	City	State	Zip	Country	Memo
   TangHsiu										Liao		7083287510	1021, South Blvd	Evanston	IL	60202	USA	Student

6. Users Administration Information Table--store the operator information.
   Primary key: UserName.
   Foreign key: FirstName, LastName, MidName.
   

   UserName						PassWord	Priority	FirstName	LastName	MidName
   Tony						Tony	2	TangHsiu	Liao

7. Demo Setup Information Table--store the demo information.

   Number		TravelPlan
   0		ocsunset.avi

8. Air-Lines Table--store all air line information, and it associates with the air line network, in order to get the newest data, and order it.
   Primary key: FlightNumber, Company
   

   Originating								Destination	Departure	Arrive	FlightNumber	Company	Aircraft	Frequency
   MDW								ATL	610a	1134a	493	NW	D95	X7

9. Hotel Table--record all hotel information which can connects to hotel network, in order to get the newest information and order it.
   Primary key: Number.
   

   Number										Name	Phone	Address	City	State	Zip	Country	H_1P	L_1P
   1										Best Western Quail Hollow Inn	6025863646	699, N Ocotillo St.	Benson	AZ	85602	USA	40	32

   H_2P											L_2P	Level	Restaurant	Cable	Pool	Meeting	24_AirCar	No_Pets	Laundry	Memo
   44											36	3	0	1	1	0	0	0	1

This page was made by Alex Tsai .

You may email any suggestions to: