Transcript Database-1 - Angelfire

Database-1
•Introduction to Database
•Introduction to Access
•Developing an application in Access
All rights reserved to Academy of Tamil Arts and Technology© 2000.Developed by Rohan.N
Introduction to Database
•
•
•
•
What is data?
What is database?
Importance of database.
Crucial stages of developing an application
All rights reserved to Academy of Tamil Arts and Technology© 2000.Developed by Rohan.N
Phases of Application
Developments
•
•
•
•
Observe the business.
Creating the tables.
Necessary Forms.
Useful Reports and Queries.
All rights reserved to Academy of Tamil Arts and Technology© 2000.Developed by Rohan.N
Application development
•
•
•
•
Importance of table design
Choosing tables
Choosing right fields
Proper data types
All rights reserved to Academy of Tamil Arts and Technology© 2000.Developed by Rohan.N
Severe stages in application
development
•
•
•
•
What is relation ship ?
Type of relation ships.
Generally used one.
Relation ships play important role in
applications.
All rights reserved to Academy of Tamil Arts and Technology© 2000.Developed by Rohan.N
Creating useful Forms
•
•
•
•
•
•
What is forms are all about?
Creating useful forms.
Editing the forms in the design mode.
Adding fields.
Doing calculations on the forms.
Adding command buttons on the form.
All rights reserved to Academy of Tamil Arts and Technology© 2000.Developed by Rohan.N
Creating useful forms(Cont)
•
•
•
•
Importance of forms.
Create the forms with the user interface.
Put sufficient control in the forms.
Good looking and keep uniforms through out
the application.
All rights reserved to Academy of Tamil Arts and Technology© 2000.Developed by Rohan.N
Queries and criteria's
•
•
•
•
•
What is query does actually?
Designing a query.
How do we write the criterions.
Types of queries.
Action queries.
All rights reserved to Academy of Tamil Arts and Technology© 2000.Developed by Rohan.N
Queries and Criteria’s(Cont)
•
•
•
•
SQL .
SQL view of your queries.
Calculations in queries.
Show, hide, sorting and expressions.
All rights reserved to Academy of Tamil Arts and Technology© 2000.Developed by Rohan.N
Type of Queries
•
•
•
•
•
Select query.
Cross tab.
Make new table query.
Delete query.
Append query.
Type of queries (Cont..)
• Purpose of query types.
• Examples of query types.
• Hands on query types.
Macros are often happen actions
in applications
• Why is macro???
• Develop an useful Macro.
• Actions can be carried out by macro.
All rights reserved to Academy of Tamil Arts and Technology© 2000.Developed by Rohan.N
Reports are climax of the
applications
•
•
•
•
Reports header/footer.
Choosing fields.
Doing calculations.
Formatting the reports.
All rights reserved to Academy of Tamil Arts and Technology© 2000.Developed by Rohan.N
Customize your application with
Visual Basic
• Edit visual basic code in the module
windows
• Set form and control properties using visual
basic.
• Display a message box.
• Final touches in your application.
All rights reserved to Academy of Tamil Arts and Technology© 2000.Developed by Rohan.N
What is Database management
system ?
•
•
•
•
Data.
Database.
Database management system.
Relational database management system.
All rights reserved to Academy of Tamil Arts and Technology© 2000.Developed by Rohan.N
Database management system
•
•
•
•
•
Entities.
Attributes.
Type of relation ships.
Relationships.
Constraints.
All rights reserved to Academy of Tamil Arts and Technology© 2000.Developed by Rohan.N
Database management
system(Cont)
• What is E.R ?
• Entity relationship diagram.
• Drawing a E.R which will expose your
Dbase knowledge.
• Applying constraints.
All rights reserved to Academy of Tamil Arts and Technology© 2000.Developed by Rohan.N
Database management
system(cont)
•
•
•
•
Participation constraints.
Cardinality ratio.
Structural constraints.
How to apply them.
All rights reserved to Academy of Tamil Arts and Technology© 2000.Developed by Rohan.N
Normalization
• What is normalization ? (Data Redundancy)
• Functional dependencies.
• Examples for functional dependencies.
All rights reserved to Academy of Tamil Arts and Technology© 2000.Developed by Rohan.N
Normalization (Cont.)
• First normal form.
• Second normal forms.
• Third normal forms / Boyce Codd normal
form
All rights reserved to Academy of Tamil Arts and Technology© 2000.Developed by Rohan.N
Are you ready for the exam?
• Thank you for taking this course and
Good luck!
All rights reserved to Academy of Tamil Arts and Technology© 2000.Developed by Rohan.N