Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community for help and clear up your study doubts
Discover the best universities in your country according to Docsity users
Free resources
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
PROJECT REPORT CAR PROJECT REPORT BCA COMPLETE PROJECT REPORt TEMPLATE
Typology: Lab Reports
1 / 41
This page cannot be seen from the preview
Don't miss anything!
We take this opportunity to express our deep sense of gratitude to our secretary SRI T.K NANJUNDAPPA and our honorable principle Dr.H.S.NIRANJANARADHYA, S.S.C.A.S.C. for providing excellent academic climate in the college that made this endeavors possible. We wish our sincere and heart full gratitude to Siddaganga College of arts, science and commerce, Tumkur, that rendered us this opportunity to have a strong base in B.Sc. and together a vast and technical knowledge. Our wholehearted admiration and deep gratitude goes to our guide and H.O.D ., LINGADEVARAPPA, M.C.A, M.Phil and for this inspiration, valuable guidance, encouragement, suggestions and overall help throughout for this successful completion of our project. We wish to record our boundless gratitude to Ramalinga reddy M.C.A, M.Phil department of the computer science S.S.C.A.S.C, Tumkur, for their guidance and encouragement during the course of this project. We would like to express our sincere and humble gratitude to all our respectful lecturers and our Lab Instructors. Mr. Irfan Ahmed M.C.A, M.Phil (PhD) Mrs.Chethana. M.C.A, M.Phil Mrs. Usha Kamala M.C.A, M.Phil Mrs. Sowjanya M.C.A, M.Phil Capt. P Arockia Swamy M.C.A, M.Phil We have indebted to our other teaching and non-teaching staff of the college and all friends for helping us in carrying out the project successful. Finally, we also indebted to our beloved parents and dear friends who were directly or indirectly helped us.
The main aim of our project is to maintain information about entire category of cars available in the showroom like their colors, exterior and interior pats and their technical specifications etc. It will also maintain the information about the customers who orders for the car. This project is designed to solve the manual work and make the work easier using computer. This project contains 15 forms having 7-8 tables, and easier for every type of data easy with validations. This project contains mainly order details where customer can order for new car, then customer details. After buying the car, the car must be registered and register number is obtained. And also the can get permit for to run the car where he requires. Coming onto servicing, the work of manual entry became very difficult because of heavy car in the service. At last, after completion of buying or servicing bill is generated based on the requirement. In our project, we maintain the stack of new cars and spares, which are available in showroom and service center respectively.
Windows has emerged the most popular user environ MS-DOS since its introduction in 1985 for the user, windows provides multitasking graphical based windowing environment that runs programs specially designed for windows. Windows have consistent appearance and command structure and are thus often easier to learn. Users can easily switch between different window programs and switch data between them. Windows also provide as easy to use icon based program manager for running program as well as a file manager and print manager of file maintenance and queue management. For the program developer, window can provide a wealth of built in routines that allow the user of menus, dialog boxes, scroll bars and other component of a friendly user interface. Windows also contain an extensive graphics programming language that includes the use of formatted text in variety of fonts. Programmers can treat the keyboard, mouse, video display, printer and system timers and communications ports in a device independent manner. Windows programs run the same on a variety of hardware configuration. Windows is a graphical user interface (GUI) sometimes also called as visual interface of graphical windowing environment. All graphical user interfaces makes use of graphics on a built mapped video display. Graphics provide a better utilization of an even real state, a visually rich environment for copying information. The video display shows unions graphical objects and in the form of icons and input devices such as buttons.
There are mainly two version of Visual Basic viz.
The standard version is designed to meet the needs of those who must occasionally write programs but are not programmers by trade or title. Here is a situation where Visual Basic’s design tools and OLE (Object Linking & Embedding) 2.0 client control save time in, building a user intake as the user wants to see and use it.
Double clicking on the icon labeled “Microsoft Visual Basic” takes us into the programming and development area of Visual Basic with its screens, windows and scroll bars. Using the keyboard or a pointing device such as a mouse the user can directly manipulate these objects on the screen. Graphics object can be dragged, button can be pushed and scroll bars can be scrolled. The BASIC (Beginners All Purpose Symbolic Instruction Code) language first developed between 1963 and 1964, immediately gained world wide acceptance and soon thousands of programmers and non-programmers were using it. Basic has continually been updated and new improved versions such as BASIC have appeared over the years. Now with windows gaining such attention due to its GUI (Graphical User Interface), BASIC has evolved to run under windows. Microsoft’s visual basic takes the older BASIC programmer to a higher and improved level of program writing for the GUI platform.
The following items have been added to visual basic to make it more usable by larger development teams. Visual basic professional 3.0 by Microsoft’s corporation allows writing professional applications for the world of windows in a reliable, part and efficient way. Visual basic professional 3.0’s capabilities may convince MIS departments, database, network and system managers and other who use higher level language such as COBOL to use the feature that this language now provides. According to Microsoft, Visual Basic is the comer store of its application programming strategy. Many of Microsoft’s applications may eventually contain derivative of Visual Basic as a common macro language that will be able to control the application and other applications through the OLE (Object Linking and Embedding) 2. Automation interface included in Visual Basic. There are six main areas in the environment-
application.
bar.
controls on forms such as text or combo boxes.
control form.
and other files that make up the entire application. For every application three processes must be done i. e. create the interface, set properties and write the code, this must be saved as a project.
Visual Basic is capable of producing software as sophisticated as any other data access technique available. There is little we can do in developer-2000 that cannot be equally implements well with ADO or 0440. We can use Visual Basic to write a text processor, an e-mail listener, or 10,001 other tasks. There is steady supply of talented staff for our development teams. Visual Basic has become popular and better supply of third party products for companies will denote their resources in which there is pay back.
ODBC is a component of WOSA (Windows Open Services Architecture). ODBC is used to interface with DBMS (Data Base Management System). A single application can access data in different DBMS through one interface. The application can be independent of the DBMS through the use of drivers. Derivers are modules that link the application to the chosen DBMS. ODBC is a more specialized form of data handling.
the results.
There are two types of ODBC drivers- one for single tier and the other for multiple tier configurations. In a single tier configuration, the database file is processed directly by the driver. In multiple tier configuration, the driver sends SQL, request sever that executes SQL requests. Most of the time, in multiple tier configurations the installation is divided into multiple platforms. The application, driver and drive manager are on a system called the client, while the database and software access are on another system called the server.
An ODBC database is a collection of tables. A table has fields and their indexes. The database can have multiple tables, each described in a tabledef statement, and each representing an object. The set of all tabledef objects the called the tabledefs collection. A tabledef object includes one or more fields. Index objects describe the organization of the table. All the fields in a table are called a field collection, and all the indexes are called the index collection.
The database object contains information about which database is open, how it can be accessed, and how it is structured. The tabledef object defines a table. It defines it be name, the collection of fields and the indexes collection. Field objects have a name, data type and size. Index objects define a key or keys, which maintain and access the actual data within a table.
A collection is a list of related objects.
The structure of a database is contained by the database tabledefs collection. The tables are defined by the contents of their field and indexes collection. Adding or deleting objects from form collection changes the structure of the database. One can create a new object, add the field and index objects to it, and then append it to the tabledefs collection. Deleting a tabledef from the tabledefs collection removes the table and all associated table data.
Only creating a temporary new object called as dynaset can access data. A dynaset is one or more tables in which the number of fields depends on how the dynaset was created. The set of fields in a dynaset is also called a field collection. These field objects differs from a tabledef object in that dynaset objects have a value property whereby it can be accessed and worked with real database values.
Tools provided by oracle are SQL+ PL/SQL Forms Reports
SQL stands for Structured Query Language. IBM was able to demonstrate has to control relational database using SQL. SQL was implemented by oracle corporation is hundred percent complained with the ANSIC/ISO standard SQL data language. It has simple command structure for a data definition, access and manipulation .SQL is set- oriented. We can perform a command on a group of data row or one row. SQL is non-procedural. When we use SQL we specify what we want to be done, not how to do it. To access data we need only to name a table and columns, we do not have to describe an access method. A table is a primary database object of SQL that is used to store data. A table holds data in the given of rows and columns. In order to communicate with the database.
the structure of database. This would involved create, replace, drop and alter or removing data base objects.
manipulating data in the database. It would include adding, modifying & removing data from the table select, insert, update & delete are the some of the
set of commands to give ACCESS, to the data in a database. SQL use the GRANT statement to give the permission & the REVOKE statement to take back the permission from user. SQL point and RDC back data control language grant and revoke commands.
A programmer’s productive tool Good user interface Powerful database structures Advancement of data manipulation Use of 4GL tools A discipline towards data independence Logical data independence Data view External view Conceptual view
Relational model Does not maintain physical connection b/w relations Data is organized in terms of rows &columns in a table The intersection of a row &column must give a single value Dynamic on-line catalog based relational model Comprehensive data sub language View updating High-level update insert delete
Physical data independence Logical data independence Integrity independence Distributed independence Non-sub version
The ability to create multiple relations & enter data into them. An interactive query language. Retrieval of information stored in more then one table. An RDBMS product has to satisfy at least six of the 12 rules of codd to be accepted as a full-fledged RDBMS.
E.F CODD formulated 12 rules for RDBMS in 1970 in addition to the 12 rules, their exist a rule called rule zero which states “a relational system must be able to manage database entirely through its relational capabilities any DBMS that advises users to some non relational methods to achieve acceptable performance should be interpreted as an apology by the vendor”.
Information representation. Guaranteed access. Systematic treatment of null value. Dynamic online catalog base relational model. Comprehensive data sub language.
Any PC compatible : Pentium 3 or Higher. Memory : 512 MB or Higher. Hard Disk : 40 GB or Higher. Operating System : Windows 98 or Higher. Mouse : Windows Compatible Mouse. Monitor : 14” inch, VGA Monitor. Key Board : 104 Keys.
Front End : Visual Basic 6. Back End : Oracle 9i
E-R shows the flow of data through a system, it views a system as function that transform the inputs into desired outputs any complex system will not perform this transformation in a “single step”, & a data will typically undergo a series of tram formation before it becomes the output. The E-R aims to capture the transformation that takes place with in a system to the input data. So that eventually the output data is produced the agent that perform the transformation of data form one state to another is called process. So, an E-R diagram shows the movement of data through the different transformation is process in system. E-R symbols: In the E-R, there are 4 symbols
