diff options
| author | mo khan <mo.khan@gmail.com> | 2020-01-14 19:34:14 -0700 |
|---|---|---|
| committer | mo khan <mo.khan@gmail.com> | 2020-01-14 19:34:14 -0700 |
| commit | 11a1d92001c24989837a2b6559ac0ac4d991f3d6 (patch) | |
| tree | ec22a7147a78ef1f2683eba03f1957e906146c01 /assignments/1 | |
| parent | a0d8582f9f04e51d6f0771c7207a0314514bbd1b (diff) | |
Remove noise
Diffstat (limited to 'assignments/1')
| -rw-r--r-- | assignments/1/README.md | 18 | ||||
| -rw-r--r-- | assignments/1/README.pdf | bin | 234807 -> 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`  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`  @@ -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 Binary files differindex ec55b12..4e925eb 100644 --- a/assignments/1/README.pdf +++ b/assignments/1/README.pdf |
