IT163M2_Part1&2_Katie Monroe_submission2
docx
keyboard_arrow_up
School
Purdue Global University *
*We aren’t endorsed by this school
Course
163
Subject
Information Systems
Date
Dec 6, 2023
Type
docx
Pages
11
Uploaded by AmbassadorFrog3399
IT163M2
Relational Databases Part 1
Dr. Cassie Longhart
By: Katie Monroe
A database is a collection of organized, structured information or data. They are designed to facilitate the storage, retrieval, modification, and deletion of data in combination with data-processing operations (Alexander & Kusleika, 2019). Databases can be used to make informed business decisions, keep track of customers or customer transactions, secure personal identity or health information, or store personal data (Lutkevich & Hughes, 2023). The information is collected in one place so that it can be observed and analyzed (Lutkevich & Hughes, 2023). A table houses the data. Tables are essential for holding all the information or data (Alexander & Kusleika, 2019). Each table is going to have one single topic (Alexander & Kusleika, 2019. A record is a collection of data relating to a single unit (Alexander & Kusleika, 2019). It can have one or more subjects. Records provide a way to store and retrieve data and each record can have different kinds of data such as a vendor record could include the vendor’s name, an ID number, vendor phone number, and email address. Fields contain different types of data with a single characteristic of a record (Alexander & Kusleika, 2019). Fields maintain relationships between tables. A value is the data where a record and field meet. The information entered represents one data value (Alexander & Kusleika, 2019). A relational database organizes and stores data in tables that are related in some capacity. A relational database system allows users to manage data relationships between information. Relational databases are made up of tables with each table having at least one data category and rows that have certain data instances for the categories (Lutkevich & Hughes, 2023). The six database objects in Microsoft Access are tables, forms, queries, reports, macros, and modules. As previously explained, tables hold the data. It’s a collection of data organized into rows and columns (Statler, 2020). They have descriptive names to reflect the types of data stored within the table (Statler, 2020). Queries help to quickly collect, read, update, create, and
delete items in a database. A query is a request for information in a formal manner (R., 2023). Reports distribute a summary of data or provide details of individual records. A report can combine multiple tables to create a forum of complex relationships among different sets of data (Alexander & Kusleika, 2019). Reports are meant to relay information in an easy-to-understand way. A macro is a function added that performs a task it is created to do. It grants you the ability to automate tasks (benadt2017, 2018). Modules are related data type definitions or to arrange object definitions together that may have a common purpose or use (
Uses of Modules
2021). The first step in the five-step design method is to analyze the requirements, determine the
users’ needs and understand how the existing process works (Alexander & Kusleika, 2019). The second step is to gather information about the database requirements and design a report to identify what data the user wants and where they want it to be (Alexander & Kusleika, 2019). The third step is to catalog all the information needed from the reports, taking notes on items that
are included in more than one report (Alexander & Kusleika, 2019). The fourth step is table design through establishing which fields are needed for each table that make up the reports. Relationships between tables can be different (Alexander & Kusleika, 2019). The fifth and final step is designing forms which consist of the fields. The forms can be one of three: labels and text
box data entry fields, special controls, or graphical objects (Alexander & Kusleika, 2019).
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
References
Alexander, M., & Kusleika, D. (2019). Access® 2019 bible
. John Wiley & Sons, Inc. Lutkevich, B., & Hughes, A. (2023, February 23). What is a database?: Definition from TechTarget
. Data Management. https://www.techtarget.com/searchdatamanagement/definition/database?
Offer=abt_pubpro_AI-Insider Statler, T. (2020, December 30). What is a database table? (concise guide)
. Comp Sci Central. https://compscicentral.com/what-is-a-database-table/ R., N. (2023, January 31). What is a query? database query explained
. Hostinger Tutorials. https://www.hostinger.com/tutorials/what-is-a-query benadt2017. (2018, October 16). What is a macro and how it’s Save Time?
Access Database Tutorial. https://accessdatabasetutorial.com/macro-save-time/ IBM Integrated Analytics System. (2021, December 17). Uses of Modules
. Uses of modules. https://www.ibm.com/docs/en/ias?topic=modules-uses