Session Date: Wednesday Nov 01, 2017
Although we will not get into relationships until the third relational database session, an understanding of how to decompose your task into related tables will help you decide how to create the tables you will later need to relate.
Read more info at the lab page. Pick one choice and be ready with it by the next class session.
A database is a collection of related data in multiple tables.
A database management system (DBMS) is designed to add, delete, and update, data in the database and to provide various ways to view on screen or in print the data. A flat file database is contained in a single table as in Excel. (You may encounter the term CRUD, which stands for Create, read, update and delete.)
Relational database are used to eliminate redundancy in storage. Relational databases make it much easier to distribute data to multiple locations. However, those responsible for a particular table, or portion of the database, must ensure that they do not alter the data in a way that breaks the relational systems.
In summary, a relational database will have multiple tables, possibly maintained in multiple locations. The relationship between these tables are carefully defined so that the entire database works together.
An entity-relationship model (ERM) is an abstract and conceptual representation of data. Entity-relationship modeling is a database modeling method, used to produce a type of conceptual schema or semantic data model of a system, often a relational database, and its requirements in a top-down fashion. Diagrams created by this process are called entity-relationship diagrams (or ER diagrams). Dedicated database classes in the School of Information and Library Science teach these models in more depth; you will be required to actually draw these out and make them. In this class, we will briefly introduce the model, but you will not necessarily need to fully grasp the theory to successfully use database systems. For example, in the introduction to Access on Lynda.com, there is not even a mention of the entity-relationship model.
Here is a youtube video on ER diagrams that you might find helpful.
If you are using a Mac, you will need to set up a way to run Access. If you chose not to install virtualization software or the ITS Virtual Lab system, you will need to use campus Windows machines for your tasks. you are also free to use the computers in our classroom.
Regardless of your operating system, you will need to save your work to a flash drive or to your OneDrive as the computers in this lab are wiped every night.
In this session will demonstrate the following steps:
This demonstration will just give you an overview of the program. Before you start plugging in real data for any personal database project, you should first make a plan.
last page update: Wednesday Nov 01, 2017