ITC556 Database system Home library solved assignment

ITC556 Database System


HOME LIBRARY MODELING SOLVED ASSIGNMENT


Insert name

Course and unit

Professor name

Institution

April 18, 2018

  

Home Library

Question 1: Functional dependency

The following represents the functional dependency between the attributes identified in the table provided in the diagram.

Figure 1: Functional Dependency Diagram

Question 2: Decomposing into 3NF Relations

The AuthorID and PublisherID attribute were introduced to support referential constraints so as to relate the three entities which are Author, Book and Publisher. Such a restructuring resulted to  3NF relations.

Figure 2: 3NF Relations

 

Question 3: Relational Schemas for 3N Relations and Referential integrity constraints.

3N Relational Schema 1: (book à author relation)

This relation is a one to many relationship (1:N). This means that there can be several instances of the Author entity in the Book entity. This relationship represents the relationship that exists between the book and author where one author can write one or many books with different ISBN.

Fig 3: 3N Relational Schema 1: (book à author relation)

Referential integrity constraints

The referential integrity constraints that exists between the Book and the Author are as follows;
  1. Primary Key (PK) – In the Book entity, there is the ISBN which is the primary key that identifies every instance in the book entity as unique. In the Author entity, there is the AuthorID which identifies each entity of the Author uniquely.

  2. Foreign Key (FK).–The AuthorID in the Book entity acts a foreign key which relates the Author entity with the Book entity.

3N Relational Schema 2: (book à publisher relation)

In this relational form, it can be depicted that there is one to many relationship (1:N). This means that there can be several instances of the Publisher entity in the Book entity. This relationship represents the relationship that exists between the Publisher and Book where one Publisher can publish one or many books with different ISBN value.

Figure 4: book à publisher relation

Referential Integrity constraints

The referential constraints between the Book and the Publisher are as follows;
  1. Foreign Key (FK). – The PublisherID in the Book entity acts a foreign key which relates the Author entity with the Book entity.

  2. Primary Key (PK) – In the Publisher entity, there is the PublisherID which identifies each entity of the Publisher entity uniquely. In the Book entity, there is the ISBN which is the primary key that identifies every instance in the book entity as unique.

Comments

Post a Comment

Popular posts from this blog

ACC030243 Corporate Governance SCU Assignment 2

ACC03043 Corporate Governance Assessment Task 2 Due Date:                          Sunday 5 August 2018 Length:                                2,000 words total (+/- 10%). Reference list and cover sheet details are not included in this word-limit total. Weighting:                        25% of total unit marks Assessment Criteria: Demonstration of knowledge of the issues and evidence of wide reading to support your analysis Demonstration of your ability to apply the knowledge to identify keys issues leading to your recommendations Evidence of sound reasoning and the exercise of professional judgement to support your recommendations Development and statement of concise recommendations for presentation to the AICD Overall structure and professional presentation of the report to the AICD High quality written communication of concepts and terms in ordinary English as not all readers of the report can be assumed to be specialists competent in corporate governance Case Study ‘
Read more

Accounting Assignment Solution

Image
Accounting Assignment Solution Are you an accounting student? Are you laden with tons with assignments, homework that is making your life immensely hectic? So, we Punjab assignment help are here to provide you the benefit of our accounting assignment Solution services, in order to get the services contact us at www.punjbassignmenthelp.com Well, you should know that you are just not the only one. Being an accountancy student is just not easy. It involves the business language of the society. Accounting involves maintenance of finances, investments and laying down all calculations for accounting assignments. A general guideline on Financial Accounting assignment solutions: Try to understand and learn the concepts well from the basic since the beginning. Just as soon as the matter starts in class, give full concentration as to what is being taught in classroom. This not only saves time but also gives you enough time to prepare. Always try to grab the concepts well. In case you are hav
Read more

CSG1207 | DATABASE DESIGN AND IMPLEMENTATION ONLINE STORE

Image
CSG1207 | DATABASE DESIGN AND IMPLEMENTATION ONLINE STORE | DATABASE COMPUTER ASSIGNMENT HELP Task 1 (Database Design) This task is to design a database for the given scenario on the following page. Your final database design should include approximately eight entities. Note: The scenario for this assignment is the same as the one from Task ¾ of Assignment 1. State any assumptions you have made regarding your database design at the starting of the database design document. Do not make any assumptions that significantly change the structure of the scenario, as this may make Task 2 of the assignment more inappropriate. You need to make assumptions that affect your database design. Finally, create a data dictionary with an entry for each entity in your database. The entries should list the entity name, a description of its purpose, a list of attributes, and details of any constraints applied to attributes. List the entries in your data dictionary in an applicable table creation order that
Read more