Sign In
Not register? Register Now!
Essay Available:
You are here: HomeEssayTechnology
Pages:
6 pages/≈1650 words
Sources:
4 Sources
Level:
Other
Subject:
Technology
Type:
Essay
Language:
English (U.S.)
Document:
MS Word
Date:
Total cost:
$ 32.4
Topic:

The Database Solution Technology Essay Research Paper (Essay Sample)

Instructions:

This was a database management system paper on entity-relationship diagrams

source..
Content:


DATABASE MANAGEMENT SYSTEMS
Assignment 3
Insert Your Name Here
Insert Your Tutor’s Name Here
Institution Affiliation
Date
CS610AH1: Database Management Systems
Assignment 3
Part 1(Entity Relationship Diagrams)
1 The entity-relationship diagram represents a model of dorm management and room allocation system in a school setup. It has three entities Dorm, Student, and Room. Entity dorm attributes are Dname, which is the primary key, numRooms, and address. Entity Room attributes are RoomNo, bunkBeds, and sharedBathroom. Entity Student attributes are Sid, which is the primary key, name, and phone. Dorm and Room are strong entities, while Room is a weak entity. The relationship constraint between Dorm and Room is one-to-many. Therefore, a dorm can have many. Room can only belong to one Dorm. The relationship constraint between Room and Student is one-to-many with a minimum cardinality of zero (optional participation), whereby a room can have 0, 1, or 2 students. A student Resides in a Room.
Room entity has no primary key because it is a weak entity; it cannot be identified by it is own attributes alone.

...
Get the Whole Paper!
Not exactly what you need?
Do you need a custom essay? Order right now:

Other Topics:

  • Research and Describe Why Kids Should Learn Technology
    Description: Science being a central subject in the school curriculum it’s very important to be taught to kids around the world due its several benefits....
    2 pages/≈550 words| No Sources | Other | Technology | Essay |
  • Wind Power
    Description: Wind power is a form of kinetic energy tapped form winds to generate electricity or harnessed to perform a mechanical task, which can be used in homes and business...
    2 pages/≈550 words| 1 Source | Other | Technology | Essay |
  • Santa Barbara Oil Spill
    Description: Which Critical Infrastructures are affected? (In this questions define the critical infrastructures and how they are affected and why?)...
    5 pages/≈1375 words| No Sources | Other | Technology | Essay |
Need a Custom Essay Written?
First time 15% Discount!