Search
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

# DATABASE SYSTEMS COURSEWORK - Essay Example

Summary
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…

## Extract of sampleDATABASE SYSTEMS COURSEWORK

The relationship type 'has_details' binds the student, invoice and room entities. As the invoice entity has details of both the student and the room and also its own properties needs to be linked with all the three to depict the relation.
d. The relationship 'reside' links student and hall entities. As students reside in the hall in a particular room.

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.

Logical model

The logical model is as follows:

The difference here is that the entities here are associated with their relationships with the cardinality ratios respectively.

The cardinality ratios are derived as follows:

1. Between student and staff (M:N).
a. 1 student is responsible to 1 staff
b. Many (M) students are responsible to 1 staff.
c. 1 staff takes responsibility of 1 student
d. Many (M) staff takes responsibility of many students.
2. Between student and hall (N:1).
a. 1 student resides in 1 hall.
b. Many (M) students reside in 1 hall.
c. 1 hall accommodates 1 student
d. Many (M) halls do not accommodate 1 student.

3. Between student, hall and invoice (1:1:1).
a. 1 invoice has details of 1 student and his hall.
b. 1 invoice does not have details of more than 1 student and their halls.
c. Many invoices do not have details of many students and different halls.

4. Between student and room (1:1).
a. 1 student...
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. ... Read More
Cite this document
• APA
• MLA
• CHICAGO
(“DATABASE SYSTEMS COURSEWORK Essay Example | Topics and Well Written Essays - 1500 words”, n.d.)
(DATABASE SYSTEMS COURSEWORK Essay Example | Topics and Well Written Essays - 1500 Words)
https://studentshare.net/miscellaneous/295737-database-systems-coursework.
“DATABASE SYSTEMS COURSEWORK Essay Example | Topics and Well Written Essays - 1500 Words”, n.d. https://studentshare.net/miscellaneous/295737-database-systems-coursework.
Click to create a comment
CHECK THESE SAMPLES - THEY ALSO FIT YOUR TOPIC
Database Systems
Besides, “Oracle Forms” is a component of Oracle Fusion Middle-ware. It is Oracle’s long-established technology for designing and developing enterprise applications efficiently and rapidly. As for another ongoing release, Oracle vestiges committed to the development of “Oracle Forms” as a component of Oracle platform.
4 Pages(1000 words)Essay
Database Systems Concepts
A classic example is the problem of security internal to a computer or an OS. If there are many users on a computer, or if a computer is being used to store passwords, what is to prevent the user from simply finding the directory with the password in it and reading?
3 Pages(750 words)Essay
A distributed database system facilitates other programs to access data from local and remote databases. Normally, a distributed database is a group of data divided into the different divisions under the management of disconnected database management systems (DBMSs) executing on autonomous computer platforms or systems.
8 Pages(2000 words)Essay
Information Systems (IS) Application: Part-Time Instructors and the Short Courses Database
According to the report organizations have adopted information systems in order to establish efficiency when it comes to the different areas of operations, ranging from the creation of system architectures that provide support for managerial decision-making through DSS to establishing a more highly coordinated supply chain.
10 Pages(2500 words)Essay
Database Information Systems Management
In the instance of our project the roles of stakeholders were defined prior to the development phase. This is good practice because the benefits of the stakeholders are known prior to the designing of the IS and their needs can be addressed The concern when developing the application was with the benefits to the stakeholders, including the students, tutors and system developer.
10 Pages(2500 words)Essay
DATABASE MANAGEMENT SYSTEMS Essay
Though both the technologies have their own advantages, disadvantages and interoperability, there are some instances where one is proffered more than the other. Hence the current study makes an insight into the minute details of the relation between XML and RDBMS to understand their true nature of complimentary and controversy.
14 Pages(3500 words)Essay
Database Systems
(RENAME(alecturerId, aunitCode, ayear)( UnitDelivery)) JOIN aunitCode = cunitCode JOIN ayear
3 Pages(750 words)Essay
DISTRIBUTED SYSTEMS
Currently, this web application can only be executed through ASP.NET Development Server which is an internal, integrated part of Visual Studio and is only suitable for testing and debugging purposes. Although, several efforts were made to use IIS (Internet
12 Pages(3000 words)Essay
Cloud database management systems
Various requirements are discussed and identified through the research. Discussions of the parameters, including the characteristic of the system,
6 Pages(1500 words)Essay
Distributed Database Management Systems
The purpose is to synchronize the data and ensure that actions like updates are in all other areas in case of multiple users. Decentralized database, on the other hand, is an example of a massive database being divided into smaller ones. The
1 Pages(250 words)Essay
Let us find you another Essay on topic DATABASE SYSTEMS COURSEWORK for FREE!
+16312120006