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

Comments (0) Cite this document
The Visio diagram in this context hence is the entity relationship diagrams. Entity relation diagrams are defined as a graphical representation of an information…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER93.8% of users find it useful
Lab 2: Modifying a Database Design in Visio
Read TextPreview

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

Creating a Database Design in Visio Unit This paper talks about the degree to which Visio diagram reflects the database design. It also entails the assumptions about business rules in order to create a Visio diagram and its relations.
Key Words: Entity relation diagram, database, Visio, schema
Creating a Database Design in Visio
Drawing an entity-relationship diagram helps understanding of an organizations required data needs and can be used to represent a schema for the required database design of the system.
a) The degree to which Visio diagram reflect the database design.
Visio is a Microsoft tool that is used for the conceptualization and construction of entity relationship diagrams. The Visio diagram in this context hence is the entity relationship diagrams. Entity relation diagrams are defined as a graphical representation of an information system that show relationships between people, objects, events and place within the information system. They enable designers to express their understanding of how the intended database will do, how it might work and communicate about the database through simple language.
Visio diagram help visualizes the database design since they make use of entity classes and attributes. 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.

b) Assumptions made about business rules in order to create a Visio diagram and its relations.
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).
Our Visio diagram has assumed some of the following business rules:
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. It means that only one teacher can teach students and many students in the course can be taught by one teacher.
Finally, more than one tutor can teach a course, and a tutor can teach many courses. It means that more tutors can teach a course, and a tutor can teach also many courses.

Andreescu, A. I., & Mircea, M. (2012). Perspectives on the Role of Business Rules in Database Design. Database Systems Journal, 59-67. Read More
Cite this document
  • APA
  • MLA
(“Lab 2: Modifying a Database Design in Visio Assignment”, n.d.)
Lab 2: Modifying a Database Design in Visio Assignment. Retrieved from
(Lab 2: Modifying a Database Design in Visio Assignment)
Lab 2: Modifying a Database Design in Visio Assignment.
“Lab 2: Modifying a Database Design in Visio Assignment”, n.d.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document

CHECK THESE SAMPLES OF Lab 2: Modifying a Database Design in Visio

Lab 2 (McNamara, 1991). The last action that was carried out was t compare the trials were gestalt was and was not presented. It should be noted that the whole process was computerized such that detection of any change could be tracked to detect the stimuli affected. The analysis of variance was then used to analyze the findings (Coren & Girgus 1980). Results The results were as shown below Based on the 2 X 5 Repeated measures ANOVA, it was found that the main effect of gestalt presence F (1, 32) = 15.637, p < .001. On the other hand, the main effect of stimuli change F (4,128) = 45.358, p < .001. By combining and correlating the two, it was found that the significant interaction between gestalt presence and stimuli change...
3 Pages(750 words)Lab Report

Database Design

...on a day-to-day basis for the quantity of gas being transported every day. Logical Design: The logical design is implemented using the Entity Relationship diagrams as follows Entities: The entities identified in the logical design of the application include 1. Customer 2. Validation 3. Meter 4. Supplier 5. Billing and Reconciliation Among the aforementioned the first four are the primary entities in the database with the Billing and Reconciliation forming the transaction in the system. This makes it clear that any trigger implemented with regards to the finance processing will reflect upon the transactions on billing and reconciliation entity...
14 Pages(3500 words)Essay

Relational Database Design

...| +----+----------------+ | 1 | Mr. Gomez | | 2 | Mr. Smith | | 3 | Mr. McClaskey | | 4 | Ms. Schwabach | | 5 | Mr. Valentino | | 6 | Ms. Racine | | 7 | Mr. Jakobowski | | 8 | Ms. Gloria | +----+----------------+ 8 rows in set (0.00 sec) mysql> II. Live Transactions. All live transactions are shown in Appendix I. These consist of the Create Database Relational. The Create Table Textbook and the other nine tables that are created in this appendix with their primary keys. III. A Non-trivial Query. All insert queries and those requiring the creation of junction tables or outside joins for the many-to-many design requirements are in this...
6 Pages(1500 words)Assignment

Database Design & Development

...Relational Database Management System Definition of RDBMS RDBMS can be defined as a set of modules that helps the organization create, maintain database at a single, centralized point. It is a database management system that is based on a popular model of relational model. This model was devised by E. F. Codd. It is a DBMS that manages the data in the form of tables, even the relation that exists between these tables in stored in the form of tables. RDBMS is based on the concept of relational system, referential integrity and normalization (Chaterjee 2005). All data is held in the form of tables and is described by the use of data values. The data which is found in the table columns...
4 Pages(1000 words)Essay

Database systems analysis & design

...System Database Design Report Table of Contents Introduction 3 System Context 3 Stakeholders 3 Requirement Analysis 4 Requirements 4 2.Business Objects (Entities) 4 Database Design 5 1.ERA Diagram 5 1.1.Entity-Relationship Model (ER Model) 6 1.2.Entity-Attribute Model (EA Model) 7 1.3.Entity-Relationship-Attribute Diagram (ERA Diagram) 8 2.Normalization 9 2.1.Un-normalised Form 9 2.2.First Normal Form (1NF) 10 2.3.Second Normal Form (2NF) 11 2.4.Third Normal Form (3NF) 11 Testing 14 Sample Test Data 14 Test Cases 15 Conclusion 18 Introduction This document demonstrates the concept of normalization while designing the...
12 Pages(3000 words)Assignment

Database Design and Implementation

...information Name Contacts Auction Start time Close time Bid price Condition Number of bids Location Quantity Item specifics Product category Product features and benefits Attributes rejected Type Brand Product Line Model MPN Operating System Screen Size Product Manufacturer Originating warehouse Total bids Winning bidder Bid increments Bid history 2. Database design 2.1 Entity Relationship Modelling 2.1.1 Initial Entity Relationship Model 2.1.2 Extended Entity Relationship Model using extended notation 2.2 Normalisation 2.2.1 General Rules for Normalisation (1NF-3NF) From the item page it is evident that there are four major...
20 Pages(5000 words)Assignment

Database Design Proposal outlined, the database will enable all the stakeholders of the health facility the convenience to get all they need to know in real-time. Using restricted access, reliability and security of data stored is assured. From analysis of the budget of designing the database, this system is cheaper than traditional filing systems. References Singh, S. (2009). Database Systems: Concepts ,Design & applications. Pearson Education India. University Of Georgia. (2013). What is a Database? Retrieved 2 11, 2013, from University of Georgia : Stubbs, D. F., & Webre, N....
3 Pages(750 words)Article

Principles of Database Design

...Principles of Database Design Principles Of Database Design Disaster Recovery and Business Continuity Plans Business continuity and disaster recovery refer to the contingency plans and measures designed and executed by a business to guarantee operational flexibility in case of any service interruptions. As information technology systems have become the focus of all areas of business, the capacity to reliably and promptly recuperate these systems have become a vital issue in any business. A Business Continuity Plan identifies a business’ vulnerability to both internal and external threats and manufactures soft and hard assets that offer efficient prevention and recovery for the business. At the same time, it retains value system... ...
2 Pages(500 words)Essay

Database design

...Database design: The database design is a very critical unit for any individual who has interest in the computer technology field. A database system is a worthy asset of any business organization. As such its administration should be effective. For one to ensure effective database management and administration, one need to fully understand the database design. The unit has enabled me gain substantial knowledge on design and management of database. The course gives a detailed introduction of database design. The introduction to database design gave me in-depth understanding of how the idea of database originated from. From the introduction, I learned that the idea of database management system arose as a result of the unending... to...
2 Pages(500 words)Essay

Database Design

...Database design Databases are the key components of successful businesses. They help businesses manage their resources efficiently. This is why pop and mom Enterprise wishes to design the following databaseDatabase Design List of entities and relationships The video store keeps stock of the videos. Customers on the other hand request for the videos. The store then rents the DVDs to the customers. The store maintains names and phone numbers for each customer. Each of the movies/DVDs in the store has a title and a unique movienumber together with serial number from the producer that is used to identify it....
1 Pages(250 words)Essay
sponsored ads
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.

Let us find you another Assignment on topic Lab 2: Modifying a Database Design in Visio for FREE!

Contact Us