204100 Lecture Homework 04 -- Data Processing and Database and Everyday Life
Important: This homework is a DOUBLE CREDIT homework. It counts as two homework.
Due Date: April 10th, 11:59pm
Answer 7 questions correct for FULL credit. Answer each question in your own words. Each question should not be longer than 3 sentences.
00. Name *
00. Student ID *
Homework Questions
Use the following pet table for questions 01 - 04
Cat can live up to 25 years
Dog can live up to 20 years
Mouse can live up to 5 years
Parrot can live up to 80 years
Use this picture for questions 01-04
01. Validation #1: Jazz 1
Do you think Jazz's age is correct? How about Oliver's age? Explain your reasoning.
02. Validation #2: Jazz 2
Is you checking Jazz's age a range check or a relation check? Explain your reasoning
03. Validation #3: Spot 1
Do you think Spot's age is correct? Explain your reasoning.
04. Validation #4: Spot 2
Is you checking Spot's age a range check or a relation check? Explain your reasoning
Use the following table for questions 05 - 07
05. A Record from the Table
Write down ONE record (what is a record?) from the table, write down its field and field values.
06. Encoding
Which field do you think will benefit from being encoded? And how?
07. CSV
Write down the data from the table, using only Employee ID, Name, and Department, in CSV format.
08. Databases in Your Life
List 3 examples of databases that you interact with in your life. At least one example must not be from the slides.
09. Data Organization
Fields __(1)__ bytes, while records ___(2)__ tables.
清除所选内容
Use the following relationships for questions 10 - 11
10. Relationship #1
Which types of relationship (1-1, 1-M, M-M) should relationship (1) be? Explain your reasoning.
11. Relationship #2
Which types of relationship (1-1, 1-M, M-M) should relationship (2) be? Explain your reasoning.
提交
清除表单内容
切勿通过 Google 表单提交密码。
此内容不是由 Google 所创建，Google 不对其作任何担保。 举报滥用行为 - 服务条款 - 隐私权政策
Google 表单