StudentShare solutions
Triangle menu

Database Design Process Project (Preparation) - Essay Example

Not dowloaded yet

Extract of sample
Database Design Process Project (Preparation)

Moreover, it offers specific built-in templates that facilitate the users to choose well suited ERD template according to the needs and requirements of the projects. Once a template has been selected by the user, the shapes (entities, relationships, category, etc.) can be drawn by just pick and drop method. The entity represents a table of a database and the relationship shape represents the relation between two tables which can be one to one, one to many, etc. After dragging an entity to the drawing board, the user can add an entity / table name, diverse columns and their names according to the requirements of the table, the data types of the created columns, selection of primary key, check / tick if a particular column must have a value and the column referred to as the foreign key (if any). In this way, the user can add several entities / tables as per the requirements of the database design under development. After adding all the entities to the drawing board, the user can add relationships between the entities by relating the primary key with foreign key and this can be done by dragging the particular shapes. Moreover, the MS Visio provides the functionalities to add triggers, indexes and notes on entities and their relationships. When the users are done with creating the entity relationship diagram, the file can be saved in .vsd format in the hard drive of the PC / laptop; moreover, the saved file can be edited or updated when required. The MS Visio offers the functionality of viewing the complete diagram, page setup and printing the diagram (Sethi, 2006). It is required for the Riordan Manufacturing Virtual Organization to develop policies, guidelines, standards and practices to put in place for the use of the MS Visio. I would suggest the organization to use the conventional standards of ERD elements to represent an entity there should be a rectangular shape along with one row having the entity name and one rectangular shape should only represent one entity. The primary key of the entity should be represented by a key symbol, the relationships between the entities should be represented with dotted lines and the color of the foreign key attribute should be red. Furthermore, the overall ER diagram should be easy to understand and precise to conceive by everyone, therefore, it is recommended that the users should add proper notes that would assist and aid the users to understand the diagram completely. It is pertinent to mention here that the MS Visio offers the same template to develop ER diagrams. The practices and guidelines for naming convention of the tables and attributes should be clarified to the employees and users of the MS Visio in the virtual organization. I would suggest to the management of the organization that the table / entity name should always start with ‘tbl’ characters, for example the entity name ‘tblCustomer’ i-e the entity or table having the information of the customer. The pre-characters of the attribute name should be understandable having first character of the table name and capital characters like the attribute name ‘cFName’ can be read as the first name of the customer. The employees of the virtual organization should be given proper training on the guidelines, standards and practices for using the MS Visio to develop the ER diagrams. The employees should be guided on saving the file names and should have ...Show more

Summary

Use of Microsoft Visio in the Riordan Manufacturing Virtual Organization The Microsoft Visio is one of the easy to use tools used for creating diverse diagrams and drawing used for different purposes. The Microsoft Visio provides the functionalities to create the Entity Relationship Diagram (ERD) in designing a database…
Author : runolfsdottirjo
Database Design Process Project (Preparation) essay example
Read Text Preview
Save Your Time for More Important Things
Let us write or edit the essay on your topic
"Database Design Process Project (Preparation)"
with a personal 20% discount.
Grab the best paper

Related Essays

Process
Based on the client’s requirements, a software team from a software development firm devises a tailor-made software solution for the client. Development of a software product is usually a process that entails extensive research, development, maintenance, modification, re-engineering and other activities aimed at creating a well-developed software product (Jawadekar, 2004).
4 pages (1000 words) Essay
Database Design
The primary entity in the validations information model is the meter assigned to the customer, as this is a unique entity for every customer. The meter assigned to the domestic customers in the market not only provides the flexibility for the organization to effectively identify the customer and his/her consumption but also provides the ability for the company to conduct regular maintenance on the meters so as to prevent any malfunctioning and abuse of the facility provided to the customers.
14 pages (3500 words) Essay
Database Design & Development
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
4 pages (1000 words) Essay
Database Design Project
When any damage to this business resource occurs then the whole business can go down or may function improperly. Through seeing this huge development in technology and its potential advantages to the business “Mayo Clinic Medical
8 pages (2000 words) Essay
Principles of Database Design
A Business Continuity Plan identifies a business’ vulnerability to both internal and external threats and manufactures soft and hard assets that offer efficient prevention
2 pages (500 words) Essay
Database Design- Dependency Diagram
These dependency diagrams are used to assist in the normalization of data in a given database. They are used to show the high level of dependence between modules in a database structure. It might
1 pages (250 words) Essay
Database Design Proposal: Analysis
However, a number of possible redundancy and coherency issues and other challenges should be acknowledged and dealt with, which are detailed below. In addition, an issue of data coherency could arise if care is not taken to different data pertaining to the same entity
3 pages (750 words) Essay
Database design and SQL Light database creation
It also has a limitation while indicating the relationships among the data entities. This diagram can be highly improved so that it illustrates clearly all the relationships. This can only be achieved through the use of the
3 pages (750 words) Essay
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
2 pages (500 words) Essay
Database Design
The unique movienumber serves as the primary key. All the movies fall under DVDs, VBS or VCD. Customers pay fines for spoilt and late return of rented videos. The customers orders for videos. They can
1 pages (250 words) Essay
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