summaryrefslogtreecommitdiff
path: root/assignments/1
diff options
context:
space:
mode:
authormo khan <mo.khan@gmail.com>2020-01-14 19:34:14 -0700
committermo khan <mo.khan@gmail.com>2020-01-14 19:34:14 -0700
commit11a1d92001c24989837a2b6559ac0ac4d991f3d6 (patch)
treeec22a7147a78ef1f2683eba03f1957e906146c01 /assignments/1
parenta0d8582f9f04e51d6f0771c7207a0314514bbd1b (diff)
Remove noise
Diffstat (limited to 'assignments/1')
-rw-r--r--assignments/1/README.md18
-rw-r--r--assignments/1/README.pdfbin234807 -> 233845 bytes
2 files changed, 7 insertions, 11 deletions
diff --git a/assignments/1/README.md b/assignments/1/README.md
index d7cf46b..751598d 100644
--- a/assignments/1/README.md
+++ b/assignments/1/README.md
@@ -1,6 +1,4 @@
-## Question 1 (15 marks)
-
-Answer the following questions (250 words max/question).
+## Question 1
* **Explain the concept of program-data independence, and explain how it is achieved in the database approach.**
@@ -30,20 +28,18 @@ Answer the following questions (250 words max/question).
* An `entity type` is a description of the data the describes the common attributes for data in a collection. i.e. the table definition.
* An `entity instance` is a specific occurrence of the `entity type`. .i.e. a specific row in a table.
-## Question 2 (15 marks)
+## Question 2
-Give a simple example of an E-R diagram for each of the following concepts:
+**Give a simple example of an E-R diagram for each of the following concepts:**
a. **Associative entity**
> An entity type that associates the instances of one or more entity types and contains attributes that are peculiar to the relationship between those entity instances.
- `Project ||-<- Policy ->-|| SoftwareLicense`
![associative entity example](./associative-entity.png)
b. **Weak entity**
* A strong entity is a type of entity that exists independent of any other entity types.
* A weak entity is a type of entity that exists when some other type exists so it is dependent on an identifying owner.
- `Customer --<- Dependent`
![weak entity example](./weak-entity.png)
@@ -56,7 +52,7 @@ c. **Unary relationship**
Group can be a subgroup of group.
-## Question 3 (20 marks)
+## Question 3
As an independent consultant, you have a contract with Athabasca University to develop an application to support
course administration. Read the following detailed description of this application, and complete the tasks listed below.
@@ -81,7 +77,7 @@ Rationale:
* An instructor can also be a student. This would yield a instructor record, student record and a single shared profile record.
* A scheduled course is a Associative entity that represents the offering of a course during a specific term.
-## Question 4 (15 marks)
+## Question 4
**For each of the following relations, identify the Normal Form(s) each relation satisfies, and transform it into 3NF.**
@@ -134,7 +130,7 @@ Rationale:
BUILDING(id, rent), Primary Key = {id}
```
-## Question 5 (20 marks)
+## Question 5
Consider a one-relation database with the following attributes:
@@ -155,7 +151,7 @@ Consider a one-relation database with the following attributes:
* Primary keys ensures global uniqueness within the relation and not null values.
* Foreign key constraints ensure that a valid corresponding relation must exist in the relation that the foreign key references.
-## Question 6 (15 marks)
+## Question 6
Consider the following relations:
diff --git a/assignments/1/README.pdf b/assignments/1/README.pdf
index ec55b12..4e925eb 100644
--- a/assignments/1/README.pdf
+++ b/assignments/1/README.pdf
Binary files differ