ࡱ> fhe =;bjbj 7d3%'''8_,|',t"))),,,,,,,$-0&,&,));,!!!)),!,!!V)@Tz*)N') +Q,0,*x5151z*z*51+!bt&,&,; ,51 : Auto Inventory Database Design  By Edward Roberts Project Name: Formal Business Report Project: D3 Auto Inventory Database Design Prepared for: Dr. Turner Prepared by: Edward Roberts March 25, 2007 Table on Contents List of Illustrations ------------------------------------------------------ page 4 Executive Summary ----------------------------------------------------- page 5 Background ------------------------------------------------------ page 5 Resources used -------------------------------------------------- page 5 Software and Hardware ---------------------------------------- page 6 End user, names, addresses ------------------------------------ page 6 Description of the project scope ------------------------------- page 6 Definition of Application deliverables ----------------------- page 6 Summary --------------------------------------------------------- page 6 Introduction --------------------------------------------------------------- page 7 Hardware ------------------------------------------------------------------ page 8 Software ------------------------------------------------------------------- page 8 End-User ------------------------------------------------------------------ page 8 Description of Project Scope ------------------------------------------- page 10 Application Deliverables ------------------------------------------------ page 11 Resources ------------------------------------------------------------------ page 11 Entity Description -------------------------------------------------------- page 13 Source Code --------------------------------------------------------------- page 14 List of Illustrations Figure 1: Context DFD Level ---------------------------------------- page 15 Figure 2: System DFD Level ---------------------------------------- page 16 Executive Summary Background This report is for Ant-Lo Auto and Taylor Car Connection, the two companies deal with buying and selling used cars to consumers. The two companies buy vehicles from individuals and auto auctions. The cars are then reconditioned and made ready to sale to the consumers. The two owners of these companies asked me (Edward Roberts) to build a program that would keep up with the past cars bought and sold during the companies operation. The program will serve as a historical database that will inform the owners about the Make, Model, Color, VIN number, Down Payment, Sticker Price, and Sale price. The report will discuss feature such as the list below: Resources used Hardware and Software End users, names, addresses Description of Project scope Definition of application deliverables Resources used This section will discuss the all the different resources and references that were being used to complete the program. Hardware and Software This section will go into detail about the hardware used to run the different types of software to build the program. Also this section will discuss the specification on the software. End user, names, addresses This next section will tell who the end users are, were they are located, and what their intentions are for the use of this software. Description of the project scope This section will discuss what was included and excluded from the project. Also this section will discuss a little about the time invested in this project. Definition of Application deliverables This last section will discuss what with program/application will deliver to the end user. Summary After the project is done, it will represent a historical document that will help the companies keep up with past vehicles that they have purchased and sold. The application will let them know if a certain vehicles is value is more then Kelly bluebook says. Also they will know a range of how much they have spent on vehicles in the past and this will inform them on how much they would spend on the same vehicle in the future. Introduction This report will discuss the methods used to build a program/application that will be used to help Ant-Lo Auto and Taylor Car Connection with keeping track with inventory and prices of vehicles that they have purchased in the past and future purchases. The purpose of the program/application will be used to help the owners know about how much they want to spend on a vehicle before they buy it; by comparing the prices they paid for the same vehicle in the past and how much they can sell that vehicle for. The purpose of this report is to inform Dr. Turner on the process of the design of the program/application and to show the setup and steps taken to complete this project. All the material for this report was gather from my knowledge and downloaded or viewed for the internet. Also there were some personal interviews conducted with the owners of the car lots. Although there are numerous ways in the approach to developing the program/application this report only discusses the ways that were approached by me to develop the application. There were a few limitations when the application was developed, such as time to put into the project because there was other work that had to be done for other classes that I am taking, and limited access to applications such as Microsoft Virtual Server. This caused a problem because all the work had to be moved from my home computer to a flash drive to take to campus. Also limited knowledge about some of the software used to build the program slow the progress of the project. Hardware Most of the hardware used to develop the application consisted of use of my home computer a Dell 4550 with Microsoft XP Home Edition version 2002. I use a Intel Pentium 4 CPU 2.53GHz with 1GB of Ram. The monitor used was a 19in View Sonic. The printer was used to print out code to be viewed and highlighted for editing. Software The software used to create this project were Macromedia products, such as Dream Weaver 8 and Cold Fusion MX 7. I also used the Cold Fusion Administer to view the webpage/database on the web. The files were stored and viewed off my local computer and modified there also. Microsoft products were used also, such as Microsoft word, excel, and access. Microsoft excel was used to put the database information in to columns and rows, then access was used to completely build the database. The access database was then uploaded to the Cold Fusion Administer to build the WebPages for the website. Notepad was used to store code that was deleted from Dream Weaver and copy that code back into Dream Weaver when needed. The internet browsers that were used to view the samples of code were Internet Explorer 7 and Mozilla Firefox 2.0. End-Users The end users that will make use of the web application will be Anthony Lonon owner of Lo Auto Sales in Athens Georgia and Rod Taylor of Taylor Car Connections in Austell Georgia. Taylor Car Connection is located 181 Maxham Rd Austell, GA 30168 (770) 732-8656. Mr. Taylor came to me with the idea of have a database website only for him to access information about his vehicles so he could compare prices of vehicles he purchased in the past to future purchase. Lo Auto Sales is located at 225 Collins Industrial B, Athens, GA (706) 549-1100, and the owner is Anthony Lonon. Mr. Lonon came to me around the same time looking for the same kind of application for his company. Both owners are in the same business and need to use the same application, which I will be developing for them, but with a different interface and different column names in the databases. Description of Project Scope This will be a Website on the end users already made website, but it will contain a password so that the end user will be the only who can access the web page. The webpage will have 4 to 5 different functions in the beginning stages, but maybe expanded upon later in the future. The functions that are implemented now are the search fields, update function, add function, and delete function. The end user will be the only ones who can use these functions to manipulate the database. This project was started January 8th and is due April 18th, this is the time period in which the project is to be worked on and completed. Application Deliverables All the pages will be linked together so that the users can access the functions from any page. In the search page the user will be able to search for vehicles by the make, model, vin number, color, down payment by customer, sticker price, and sale price. The fields will be able to be left blank accept for the make and model. The update page will be used to add in the fields that were left out during the creation of the new entry. The add page will be used to create a new vehicle in the database. The delete function will be used to delete any data out of the database. The application will search thru the database using the primary key ID, which is the automatic numbering in the database. The webpage will have a password link built into the page so that the user will have to have a password to login. Resources The resources used to complete the applications consist of books, internet, and web forums. The books used were ColdFusion MX7 web application construction kit, Macromedia Dreamweaver 8 unleashed, and Using Macromedia Studio 8. There were websites on the internet that guided me in the process of completing the application; here are a few that I used: www.adobe.com http://www.quackit.com/coldfusion/coldfusion_tutorial.cfm www.yahoo.com/questions http://www.cfdeveloper.co.uk/forum/forum_posts.asp?TID=509 http://www.hyperteach.com/products/coldfusionmx7-video-cd.htm http://www.houseoffusion.com/signin/logout.cfm Object Type Object Label Dictionary ID Entity Customer LOA00 Method of Data Handling N/A Text Description and Comments Anyone who comes in the shop and purchases a vehicle. Object Type Object Label Dictionary ID Entity Employee LOA00 Method of Data Handling N/A Text Description and Comments Commission employees are anyone who manages specific areas such as sales, financial, and promotions for the company. Hourly employees who are receptionist, repair specialist, or provide any services in the company. Object Type Object Label Dictionary ID Entity Owner LOA00 Method of Data Handling N/A Text Description and Comments Responsible for leading the employees, marketing and evaluating the promotions, programs, and developing training for employees involved in the company. Object Type Object Label Dictionary ID Entity Suppliers LOA00 Method of Data Handling N/A Text Description and Comments Companies and individuals that supply vehicles, equipment to repair vehicles, web site designers, and database designers. Object Type Object Label Dictionary ID Data Store External LOA00 Method of Data Handling N/A Text Description and Comments Government guidelines Object Type Object Label Dictionary ID Data Store Internal LOA00 Method of Data Handling N/A Text Description and Comments Sample Code index page
    PAGE  PAGE 6 !"#%67j c d   Q R *HOP[\wxy{ +79ɿퟛhZhO,h,hvh{hAh hJfAhJfAhJfAhgh\hg\ hg\ h]\ hJfA\ h\\h\h\\h\ h]h]h]hh,hXZjhXZhXZUh,3 !#$%78]^jklmnopqrstuvwxy$a$gdXZ$a$gd,gd,$a$gd,y$a$gdXZgdXZ$a$gdXZ    d e  K L `gdgdgdXZ$a$gdXZ$a$gdXZ $ j  Z  R S PQgdJfA$a$gdggdggd\gd]dgd] d`gd`gd\]^_`abcdefghijklmnopqrstugdJfAgdJfAuvwxy)*9Ok6789O & FdgdZdgdZ $da$gdZ$a$gd$a$gdJfAgdJfA#hi M"N"X"*$ $da$gdZdgdZ $da$gdZ:=C  _!`!" "8"G"L"M"""" #.#<#\#)$*$8$F$j$k$x$$%ŽнвЮhJ/B*phh`B*phh`h`B*phh{_ hJ/hJ/hJ/hvh` h9wh9whRh hq h+h+h&h+h&Oh ,Zh^qhD^h{h6"h,h,h-hW&3%%%%%''''''M(N(g()b*c*%++++++,,F,H,R,j,p,,,,, ---P-Q-h-i-----.......//k/ӐӐӉ h[hZhZ5CJaJh+ h{$h{$h{h{$h{>*h{$h{$>*h{$h#h&O h`hW&h`hJ/hZhMhMH*hMhW&h5h{_hJ/B*phh{_B*ph6*$%%%'M(N(g(+++ --Q-i---......  PgdZgd{$ & FdgdZ$a$gdZdgdZ $da$gdZdgdZ.......... .!.".#.$.%.&.'.(.).*.+.,.-.../.0.1.2.  PgdZ2.3.4.........///k/l////////0;0000  PdgdZ  PgdZk/////////;0K0L0T0000011 1&1D1F1N1j1m1111111111192Q2R2j2o222 3 3e3333333,4G4H4`4f44Ľ쵪 hDhZhnFhZ5 hnFhZhnFhZB*phhZB*ph hYhZ hZ5hYhZ5B*phhZ5B*phh[hZ5CJaJhZ5CJaJ h[hZhZ9001 1!1%1&1D1E111111192:2Q2R2j2k2o22222 3 3 3  PgdZ 3 333e3f33333333333,4-4G4H4`4a4e4f444444  PgdZ4444 ;;;;;;;;;;;;";#;$;&;';-;.;/;0;1;3;4;;;<;=;h|'hPX0JmHnHu hSuB0JjhSuB0JUh=jh=UhSuB hghghgh{$444444445 5%5?5C5L5T5555O666@778e88*929gdg$a$gdg  PgdZ2939:99g:; ;;;;;;;;;;;$;%;&;1;2;3;4;5;6;7;h]hgdd &`#$gd~ .gdg7;8;9;:;;;<;=;gdg5 01h:pd/ =!"#$% Dd( 0 + N  C *Aj031981024 ~p"=FD `!4 ~p"=Fj.xڭy/k!d'ƾ#ci,%Id D2k,a enBYC˷$|9?~Ιsz_D.)'QF"! Mn󩡧̙_?sxɂ??sXBAH_ԺpLj[ryh9G2Eq;]l<83@c `,L `[/C[Űu%ﱲ}Fn~;>[N9rTA&{d>,~W ,sx!ϓ*KkZ2nuh{^,_7K iJn^OuL咠s!u,ѭZO&/`!-Nh9V{Ix ݥ-7X.+MI=Ux7\ei\I)>_JomzY~r*$5+j!TTQ]Hk/ H/{FChz%(NFPMy TM?q':W8HEՓ4RFIHFzSIv7EGF1,SBr/V_[Gb< IahollFJ.EkeldPվKXfK*m򢵕XI K/9Lƌ2{c?̴s.@%pIeh<V>W p*ҏT$SV'T4 gi =CoQANyUF`g[/GXm^A/0 `5zd$xTT~`0|36ڧžd<.' JK{+;ΚI+X#6Rz` 2QD vXiZZu_y3. N[SI$_;l",# Kf*#E܆nXsJ-Krڃrz q\O'%),Q~d9k,>rQM#w2Tˌ 9\Aʅ\)xdݳ@+R7x^&hR1](-  z~-ZL7i 3&z(='y?C/9z_CWzgK>]%۾Y*Ȅ#ַhd!FF2Dmls5V$mb;4}6v[bWݲힽgl=j|lvK Uݽ@OS']:(z(jAc%MXNhNԚրMhtJJ(']LeyUTS'b=' H 0Q`oOL7 >9@{8n #_|n$Ϗ(<\s8Ҡ,(*PCR<Ń`Y O-ܧӈDR߈^e9ͭz]K&ź=67_EtuR^$#hCJ/D^}!ҟ;--܋g+<[r+˕||+<۩%"^Mm%jek(@ Vl;7N5cTNS@*e_7G!֜&n+4g!0`K|*8[z4ׂJ>?hs ?=}[_\6ZUf췃`8 k' [ZcN0gy?t샫EN/!T s#ZbDsLwe$4Yz!~ iK@ҊHK `w kLy]C皁߽s?0P7 S'S|F!'3O/}.TCa2ZHΥ58G6u@mz]uZtׄ{zi>5'yxZӢGKp-,_ךn^z_ hoN&Oy}/˝}IE96zKA$UHP&|pN_`2] ޢkA+9Vm(J#{11Օή2Żդ֠EѮ6suK]=z5<ГB8>)銡Maz奖o{WYW2!}iFBT}hx+Zi7JUVm~YVeNna&-E6[o]=@k!iC4}D\Hp3hMS\  *Vk( ߟ!r:!|vYP TAǂ8xiL7v=o~]0,l_ZǺ/Ҽw͵jYVw}{Ojm5|sn&jiF,Fw^4 $䛩xO:3'=o|/|#% $6|L{V):)y\TBoқ1DP7x\,(  nk{< #m r֠}TA4 Qr |.A'{t,(G<+@=$lgcmz/ԕ|%u$F u}jE^ 2 0@P`p2( 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p8XV~_HmH nH sH tH @`@ NormalCJ_HaJmH sH tH Z@Z , Heading 1$<@&5CJ KH OJQJ\^JaJ DA`D Default Paragraph FontRiR  Table Normal4 l4a (k (No List 4 4 -Footer  !.)@. - Page Number4U4 ` Hyperlink >*ph4@"4 dHeader  !PK![Content_Types].xmlj0Eжr(΢Iw},-j4 wP-t#bΙ{UTU^hd}㨫)*1P' ^W0)T9<l#$yi};~@(Hu* Dנz/0ǰ $ X3aZ,D0j~3߶b~i>3\`?/[G\!-Rk.sԻ..a濭?PK!֧6 _rels/.relsj0 }Q%v/C/}(h"O = C?hv=Ʌ%[xp{۵_Pѣ<1H0ORBdJE4b$q_6LR7`0̞O,En7Lib/SeеPK!kytheme/theme/themeManager.xml M @}w7c(EbˮCAǠҟ7՛K Y, e.|,H,lxɴIsQ}#Ր ֵ+!,^$j=GW)E+& 8PK!Ptheme/theme/theme1.xmlYOo6w toc'vuر-MniP@I}úama[إ4:lЯGRX^6؊>$ !)O^rC$y@/yH*񄴽)޵߻UDb`}"qۋJחX^)I`nEp)liV[]1M<OP6r=zgbIguSebORD۫qu gZo~ٺlAplxpT0+[}`jzAV2Fi@qv֬5\|ʜ̭NleXdsjcs7f W+Ն7`g ȘJj|h(KD- dXiJ؇(x$( :;˹! I_TS 1?E??ZBΪmU/?~xY'y5g&΋/ɋ>GMGeD3Vq%'#q$8K)fw9:ĵ x}rxwr:\TZaG*y8IjbRc|XŻǿI u3KGnD1NIBs RuK>V.EL+M2#'fi ~V vl{u8zH *:(W☕ ~JTe\O*tHGHY}KNP*ݾ˦TѼ9/#A7qZ$*c?qUnwN%Oi4 =3ڗP 1Pm \\9Mؓ2aD];Yt\[x]}Wr|]g- eW )6-rCSj id DЇAΜIqbJ#x꺃 6k#ASh&ʌt(Q%p%m&]caSl=X\P1Mh9MVdDAaVB[݈fJíP|8 քAV^f Hn- "d>znNJ ة>b&2vKyϼD:,AGm\nziÙ.uχYC6OMf3or$5NHT[XF64T,ќM0E)`#5XY`פ;%1U٥m;R>QD DcpU'&LE/pm%]8firS4d 7y\`JnίI R3U~7+׸#m qBiDi*L69mY&iHE=(K&N!V.KeLDĕ{D vEꦚdeNƟe(MN9ߜR6&3(a/DUz<{ˊYȳV)9Z[4^n5!J?Q3eBoCM m<.vpIYfZY_p[=al-Y}Nc͙ŋ4vfavl'SA8|*u{-ߟ0%M07%<ҍPK! ѐ'theme/theme/_rels/themeManager.xml.relsM 0wooӺ&݈Э5 6?$Q ,.aic21h:qm@RN;d`o7gK(M&$R(.1r'JЊT8V"AȻHu}|$b{P8g/]QAsم(#L[PK-![Content_Types].xmlPK-!֧6 +_rels/.relsPK-!kytheme/theme/themeManager.xmlPK-!Ptheme/theme/theme1.xmlPK-! ѐ' theme/theme/_rels/themeManager.xml.relsPK] =3 =3d $$$$$'%k/4=;&'+.y u*$.2.0 34297;=; !"#$%()*,-/01  '!!8@0(  B S  ?=3,L,L,, ,L,,, ,,,,L, ,L ..<EH``h>3        ;CGMMfjj>3   B *urn:schemas-microsoft-com:office:smarttagscountry-region8*urn:schemas-microsoft-com:office:smarttagsCity:*urn:schemas-microsoft-com:office:smarttagsStreet>*urn:schemas-microsoft-com:office:smarttags PostalCode;*urn:schemas-microsoft-com:office:smarttagsaddress9*urn:schemas-microsoft-com:office:smarttagsState9 *urn:schemas-microsoft-com:office:smarttagsplace  P   28!!!,,--Z-a-l-v-{----------8.C.T.[.\.a.t.z.............//^/a/b/e/////!0$0%0(000000000.1016181A1H1M1T1111122 222$2|222222 3 33333333333333343>3UV!!!&'(())**,,,,,,,,--O.S....1016181 3 33333333333333343>33333333333333333Onwxy( ) * + :=H$R$$$$$,3333333333333#3&30333434353536363737383839393:3:3;3>3( ) * + :=H$R$$$$$3333333333333343>3P-Xu&^R'7%vt9h  ^ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh| | ^| `OJQJo(hHhLL^L`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHh^`OJQJo(hHhTT^T`OJQJ^Jo(hHoh$ $ ^$ `OJQJo(hHh  ^ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHhdd^d`OJQJo(hHh44^4`OJQJ^Jo(hHoh^`OJQJo(hHP-&'7%v                            $&3Sbm"'-K(3Sb 6.h=3Sb*IXBWXBWm"'x^3Sb~Cky~Cky*I/.-9w#,{$&O,~ .5JfASuB&OuU5YZ ,ZXZD^^q,MPXJ/6"W&v{A=+%{_d|' gv,R\`-]q33@i i Hi i =3@UnknownG* Times New Roman5Symbol3. * Arial?= * Courier New;WingdingsA BCambria Math"1h44q+\q+\4d22 2QHX ?,2!xxAuto Inventory Database DesignEdward RobertsEdward Roberts   Oh+'0 (4 T ` lx Auto Inventory Database DesignEdward Roberts Normal.dotmEdward Roberts2Microsoft Office Word@Ik@9N@9Nq+՜.+,0 hp  Home Network\2 Auto Inventory Database Design Title  !"#$%&'()*+,-./012456789:;=>?@ABCDEFGHIJKLMNOPQRSTVWXYZ[\^_`abcdgRoot Entry FYNiData 31Table<M1WordDocument7dSummaryInformation(UDocumentSummaryInformation8]CompObjy  F'Microsoft Office Word 97-2003 Document MSWordDocWord.Document.89q