INFS 247 Lecture Notes - Lecture 5: Database Model, Data Management, Database
19 Jun 2018
School
Department
Course
Professor
INFS Lecture 5
Databases
Database – Structured collection of related data stored on a computer medium
oOrganizes data in a way that facilitates efficient access to the information captured in
the data
DBMS
oUsed for
Creation
Manipulating data
Maintenance of database
Steps
Database requirements
oCollection
oDefinition
oVisualization
First and most crucial step
Specifying which data the database will hold
oConceptual database model – A visualization of requirements by using a conceptual data
modeling technique
Database Modeling (Logical database modeling)
oCreate database model
oRelational database model is most common
Database Implementation
oUsing DBMS to implement the database model as an actual database
oMost use a relational DBMS
Developing Front-end Applications
oDesigning and creating applications for indirect use by the end users
Database deployment
find more resources at oneclass.com
find more resources at oneclass.com
Document Summary
Database structured collection of related data stored on a computer medium: organizes data in a way that facilitates efficient access to the information captured in the data. Specifying which data the database will hold: conceptual database model a visualization of requirements by using a conceptual data modeling technique. Database modeling (logical database modeling: create database model, relational database model is most common. Database implementation: using dbms to implement the database model as an actual database, most use a relational dbms. Developing front-end applications: designing and creating applications for indirect use by the end users. Database deployment: releasing database system for use by users. Database use: the insertion, modification, deletion and retrieval of the data in the db system. Database administration and maintenance: performing activities that support the database end user, including dealing with technical issues. Entity-relationship (er) modeling conceptual database modeling technique. Er diagram (erd) the result of er modeling.
