DATABASE SYSTEMS COURSEWORK

Undergraduate
Essay
Miscellaneous
Pages 6 (1506 words)
Download 0
The above table of entities and their attributes follows from the analysis of the case study. These entities form the master entities and others will follow from the logical and conceptual relationships between these entities.
b. The relationship type 'rents' is linking the student and the room…

Introduction


This conceptual model depicts all the entities and their relations; it gives the overall picture and understanding of the system to a novice. This can also be called a logical model as it does not take into consideration any DBMS in mind and shows the logical association of the system.
Next we are constructing the logical system which has the cardinality ratios. A cardinality ratio of a binary relation is the maximum number of instances an entity can participate in a given relationship type.
Special note: The attribute named 'lease' to the relationship named 'rent' has been shifted to the rent table as the cardinality ratio is 1:1 so any attribute of the relationship type must be shifted on either side.
The arrows show the functional dependencies. The single arrow with no point head determines all the attributes of the entire entity. In the table 'Responsible_For' which was previously a relationship between student and staff had a cardinality ratio of M:N. The relationship type will form a separate table with the same name having the primary keys of both the aligned tables.
a. Only the table 'Room' has an attribute called 'Room Type' which can have both 'single' and 'double' rooms in a particular hall. ...
Download paper
Not exactly what you need?

Related papers

Database Management System
The following assumptions are derived from the above diagram: 1. The pointer with arrow head shows the dependent variable and the pointer with no arrow head shows the determinant variable. 2. There are 3 functional dependencies as shown above in the diagram.
Database Information Systems Management
It is good practice during this phase of development to endure that the IS progressed to endure the desired benefits and it is bad practice to progress with the development if these desired benefits have not been realized.1 Fortunately in our project the benefits of the stakeholders had been define and benefits realized. These are important aspects of application development because they determine…
DATABASE SYSTEMS COURSEWORK
This conceptual model depicts all the entities and their relations; it gives the overall picture and understanding of the system to a novice. This can also be called a logical model as it does not take into consideration any DBMS in mind and shows the logical association of the system.…
Database Systems
Conflicts may occur which likely to generate erroneous outcomes. Notice the precedence graphs are acyclic, that is, they do not have loops. Thus, they cannot represent cyclic computations. Since many of the computations in operating systems are cyclical, this is a strong restriction.…
Database management Coursework
select distinct Customer.CustNo, Customer.CustFirstName, Customer.CustLastName, Customer.CustBal from Customer, OrderTbl where Customer.CustNo = OrderTbl.CustNo and (OrderTbl.OrdDate between '01-Feb-2007' and '28-Feb-2007);…
Information Systems in Business and Organizations Coursework
Because this employee expertise is so important to them, the first step businesses must take to improve their capability of creating knowledge out of information is to understand its 'deep smarts'- what they are, how they are built and how they can be transferred to be made useful (Leonard & Swap, 2008).…