Database Design Process Project (Preparation)

Database Design Process Project (Preparation) Essay example
Masters
Essay
Design & Technology
Pages 3 (753 words)
Download 0
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…

Introduction

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. ...
Download paper
Not exactly what you need?

Related papers

Enterprise Software Architecture Design The Project Proposal, Requirements and Architectural Model(s)
Basically, enterprise architecture describes the enterprise components, composition and terminologies and their relationship with external environment. Furthermore, it also describes analysis guiding principles, evolution of the enterprise and design. Enterprise architectural design is a comprehensive description of an enterprise goals, roles, business process, organizational behavior,…
Design
Ideally, patents are granted to inventors or to their assignees for a set duration of time and they require that the inventor publicises the invention. International agreements offer a bridge between different countries’ patent laws and protect inventors from global competition. For instance, the World Trade Organisation (WTO) established the agreement on trade-related aspects of intellectual…
Discuss how the engineering design process works for a mechanical component (in this case a lifting device) in an industrial set
The process steps in some instances appear sequential, although, in some cases with light of changing design models the steps may be reverse or parallel to one another. Every design situation has unique set of demands and criteria, thus, choosing a design process will be dependent on the specific needs of the project (Lumsdaine et al 1999). The design process would normally entail an entire…
Project report about the proposed design of an environmentally friendly HYBRID car that works by Fuel and Battery nd nicknamed (
Properties of option 1 and 2………….……….17 Figures: Figure 1: BMW Turbo Charged Engine…………………………….…………9 Figure 2: Naturally Aspirated Engine…………………………………….……10 Figure 3: Hybrid Car Engine…………………………………………………….11 Figure 4: Hi-Eco Car Engine Storage…
Design Process Technical Research Paper
This paper discusses the history of goal-line technology, the societal needs it serves, operation, and the notable design processes that has aided its development. The History of Goal-line Technology Different football stakeholders around the world have made the calls for the technology. These calls have intensified since 2010 in the English Premier League (EPL), recent World Cup games, and the…
Design Process Technical Research Paper (car breaks)
This foot pressure is necessary in order to actuate brakes. Typically, this can be reduced by making the master cylinder pistons’ surface are smaller compared to the surface area of other piston’s in the wheel cylinders or calipers. The braking systems master cylinder has a fluid reservoir, double cylinder, and piston assembly. These double-type master cylinders are designed to separate front…
heat exchanger design project
The Flowrate of the system is to be designed to be 10,560 kg/hr The design also aims at getting the heat exchanger using hot Ethylene glycol which at the inlet shall be at a temperature of 350 K. At the outlet, the design is to have the hot ethylene at the temperature of 310K. At the same time, the design Pressure at the inlet is to be 2 atm. 2 Background Shell and Tube Heat Exchangers A shell and…