Worksheet assigned from 11/14/2017-11/21/2017 class.
· You may use this worksheet during the in-class quiz on 11/28/2017.
· This worksheet MUST be printed for use during the quiz; you may not access the worksheet on-line using your laptop or phone. You may type or write information on the worksheet.
· You may not share worksheets.
· Only the worksheet may be referenced during the quiz; you cannot use the text or your notes.
Note:
1. Come prepared with the following:
- MS Access – either installed on your laptop or available via Citrix
- Jump Drive – Be sure that if you are using MS Access over Citrix that you are able to save/retrieve your MS Access file to your Jump Drive
- 1Apps username/password
- NVU – either installed or available via Citrix
Ethics Assignment
Nothing will be collected, but remember to keep making progress on the ethics assignment. It is due on December 5, 2017.
Quiz from 11/14/2017 – Remember to complete the 11/14/2017 quiz. It WILL be collected at the beginning of class.
Reading: Read Chapter 5 and be sure you know the vocabulary at the end of the chapter.
Midterm questions: Review the midterm questions passed out in class so far. Remember that you had to actually attend class to receive a copy. If you did not attend, get a copy from another student. We will go over the answers to the last 2 sets passed out as we have not yet reviewed them. There will be one or two questions from the midterm on next Tuesday’s quiz.
From MS Access: I *may* walk around the room and look at this assignment, or I *may not*. (We will both be surprised.) If I do walk around the room to look at it, it will count as 10 points. As I did not walk around the room last class, it is likely I will do so this time. Use the posted solution as a starting point.
MS Access Assignment:
1. Generate a report that is grouped by Car Color and includes the fields
a. Seller Name
b. Seller Phone
c. Car Cost
d. Car Rating
2. Generate a SQL statement that selects cars with a rating greater than 3. Include the fields
a. Seller Name
b. Seller Phone
c. Car Cost
d. Car Rating
3. Generate a report from the above SQL statement. Call the report Highly Rated Cars
a. Make sure that you modify the labels to appear grammatically correct.
Web page assignment
The web page assignment is due by the time of the final exam. If you look at the class web page, you will see that there is a link to a sample web page with all the essential elements. Those who attended class on 11/22/2017 should have a completed or nearly complete assignment. Those who attended the week before the Thanksgiving holiday have all the base skills needed to complete it independently.
Questions from lecture and Chapter 4 material and MS Access:
1. What are the 4 operations all organizations must be able to perform on data?
2. Using the below table as a reference, write an SQL statement to do the following: Select the names and costs of all products costing less than $10.
Product
ProductID / ProductName / ProductMfrID / ProductCost3. Using the above table as a reference
- What is the primary key?
- What is the foreign key?
4. What is an example of a desktop database management system?
5. What is an example of an enterprise database management system?
6. What are the 4 v’s of BIG Data?
7. What are the 3 layers of a software system?
8. What is the term MS access uses for the GUI?
9. Explain how a combo-box or dropdown helps to protect data.
10. The relationship between a student and a student id is 1:1 (1 to 1). A student has one student id and a student id references only one student. Give an example of a 1:1 relationship with respect to the US tax system.
11. The relationship between a patient and physician is n:m. A patient sees many doctors and a doctor sees many patients. Give an example of a n:m relationship with respect to the Banner System.
12. In some health insurance systems, a patient must have a primary care provider. A patient has one primary care provider and a primary care provider can see many patients. That relationship is 1:m. Give an example of a 1:m relationship in the Banner system.
13. What is another term that is used for the relationships described in the above questions? Hint: It starts with a ‘c’.
14. Explain what ‘enforcing referential integrity’ does with respect to the Car database and specifically the Car color and the Car table.
15. What is the file extension of a MS Access database?