Data Validation This week we will learn about the many kinds of data validation that exists for Excel workbooks. Do some research and find a resource about data validation and why it is important to your work. How many different ways are there to validate the data that gets into a workbook? Any outside resource […]

Creating and Using Forms and Reports Forms in Access are like display cases in stores that make it easier to view or get the items that you want. Since forms are objects through which you or other users can add, edit, or display the data stored in your Access database, then why is the design […]

Requirements Analysis and Conceptual Design (graded) Describe some typical pairs of entities that you think might be common in business, and describe their relationships, whether many-to-many, one-to-many, many-to-one, or one-to-one. Explain why you think that a particular relationship applies to that pair of entities.   Why do you think organizing data into tables and relationships […]

Gathering Requirements and Choosing Database Solution (graded) Why are databases important to business? How do databases generate sales and profits? What databases do you interact with, and how do they benefit you?   What is meant by requirements gathering, and why is it important to clearly define the data requirements of a database before creating […]

Gathering Requirements and Choosing Database Solution (graded) Why are databases important to business? How do databases generate sales and profits? What databases do you interact with, and how do they benefit you?   What is meant by requirements gathering, and why is it important to clearly define the data requirements of a database before creating […]

Class, looking back over the Course Objectives for this course, what are you looking forward to learning more about throughout your education and career? Have you already been able to apply course concepts where you work?

Integrated Applications When a business/firm grows and has their data in different places and on different documents/spreadsheets, why is integrating data so important to the business/firm?   Why is data security important now more than ever? What are some of the steps that we can take to ensure that our database is protected and secure? […]

Gathering Requirements and Choosing Database Solution (graded) Why are databases important to business? How do databases generate sales and profits? What databases do you interact with, and how do they benefit you?   What is meant by requirements gathering, and why is it important to clearly define the data requirements of a database before creating […]

A small surgery center needs your help to create a database. The office manager has identified the following types of data (entities): patients, doctors, procedures and appointments using the following business rules:   Patients can have many doctors and many doctors can see many patients.   Patients can have many procedures and many procedures are […]

Complete Lab 3—Database design using Visio based on data requirements and business rules. Detailed instructions and requirements can be found in the Lab area for this week.   Don’t forget to submit your lab for grading.