StudentShare solutions
Triangle menu

Lab 2: Modifying a Database Design in Visio - Assignment Example

Not dowloaded yet

Extract of sample
Lab 2: Modifying a Database Design in Visio

An object type is identified by a noun and in some cases it may be strong or weak entity class. A Strong object type is represented by a triangle and a weak entity class by a triangle inside another triangle. Attributes collectively represent the object class. Attributes by themselves are meaningless and cannot clearly define themselves. In the Visio diagrams, they are usually symbolized by an oval.
Attributes are what is stored in the database hence gives a clear view of how the database would appear. Example: student has a student Id, name and course. In the above example, student is the entity class and student Id, name and course are attributes. Some attributes have a primary key. The key is preferably composed of only a single attribute, but in some cases, more than one.
The final element of entity relation diagram is the relationship. Entities have relationships between them and should be represented where appropriate. Relationship are represented by a diamond and two connecting lines.
Business rule is a statement that imposes some constraint on some particular aspect of the database. You base a business rule based on the organization views and usage of its data, which you determine from the way in which the body performs or conducts its affairs.
Ways of doing things are unique and has different requirements in each group. An example is a club having more than one student and the student not being a member of more than one club. Therefore, there is a constraint on the student’s membership on a given number of clubs (Andreescu & Mircea, 2012).
First, the course can have more than one student partaking it and more than one student can be part of the course. It means, many students will be taking a course, and a student can also do many courses.
Secondly, more than one student can be taught by an instructor, and only one instructor can teach many students. ...Show more

Summary

The Visio diagram in this context hence is the entity relationship diagrams. Entity relation diagrams are defined as a graphical representation of an information…
Author : joncruickshank
Lab 2: Modifying a Database Design in Visio essay example
Read Text Preview
Save Your Time for More Important Things
Let us write or edit the assignment on your topic
"Lab 2: Modifying a Database Design in Visio"
with a personal 20% discount.
Grab the best paper

Related Essays

Database Design Concepts: 'British Insurance Company' Case Study
Here, the admin will be able to add new customers, view existing customers and delete a customer. An admin will also be able to perform a customer related search in the search box provided at the bottom of the page. When the admin will click on any of the buttons, he will be redirected to the related page.
14 pages (3500 words) Assignment
Database assignment 2
The final stage is the mapping of the Global Model to the other applications. The mapping will be able to show the relationship that exists between different entities within the organization. Company Selection The company selected for this project is Budget Transportation firm.
10 pages (2500 words) Assignment
Database Design and Implementation
Each book has a book number, title, the number of pages of the books, the name of the publisher, the year of publishing, and list of authors of the book. Each library could own zero to several copies of the same book. The database might store the author's name of each book and other information.
10 pages (2500 words) Assignment
Relational Database Design
The Relational Database specification required nine table in the following relationships. A table Textbook with a many-to-many relationship through a junction table (outside join) to the table Module through the Module_Detail table. A many-to-many relationship is required between Module and Field through a join table (outer join or junction table) Field_Detail.
6 pages (1500 words) Assignment
Database
Each asset is regularly inspected, and the date of the inspection, the person who carried out the inspection and details of any maintenance actions are noted. If the asset is a photocopier then the toner is replaced and the total number of copies made is recorded as well as the toner serial number.
4 pages (1000 words) Assignment
Database application, Planning, Design, and Implementation
The most apparent instance of a non computerized database is a telephone directory. On the other hand, telephone companies at the present time make use of an electronic database program to turn out their
1 pages (250 words) Assignment
Database systems analysis & design
It then highlights how the design confirms the three forms of normalization i.e. 1NF, 2NF and 3NF. In order to test the working of the proposed logical design, results of certain test cases have also been presented. The
12 pages (3000 words) Assignment
Database Design and Implementation
A major pitfall exists in the payment duration; the buyer’s payment can take up to a fortnight since it goes through Ubid which can cause a serious cash flow problem for the new sellers. E-bid auction is one of the largest auction sites in the UK. It is the second
20 pages (5000 words) Assignment
Database and Data Warehousing Design
There is a storage space of data warehouses for maintaining the historical in addition to the most recent data. This historical data is designed to develop and enhance diverse fads and records available to the senior management in a way that the management makes use of the
11 pages (2750 words) Assignment
Lab report 2
Content of one DPD total chlorine powder pillow powder was then added and the readings taken In conclusion, the concentration of iron in the Lake Water and secondary treatment water is the same. While the total chlorine water in pool
2 pages (500 words) Assignment
Get a custom paper written
by a pro under your requirements!
Win a special DISCOUNT!
Put in your e-mail and click the button with your lucky finger
Your email
YOUR PRIZE:
Apply my DISCOUNT
Comments (0)
Rate this paper:
Thank you! Your comment has been sent and will be posted after moderation