Database Design Life Cycle Essay

Submitted By Ntmd8r03C
Words: 658
Pages: 3
Open Document
Database Design Life Cycle

Requirements Analysis

The end state of this database is that the supervisor and forensic examiners of the digital forensics unit will be able to access both historical and current data on the forensics examinations processed thought the forensics lab. Statistical data will be available as it relates to the types of crimes that require digital forensic examinations, if there are cases that involve repeat offenders and the success rate of closed cases.
Design
Conceptual At the conceptual level of the database design the necessary entities will be defined. A root entity and the child entities will be defined. For this database the Digital Forensics Unit will be the root entity and will have three child entities for Investigator, Suspect and Forensic Examiner. Each entity will have a relationship to the other two.
Logical

At the logical level the information that will be contained within the entities and what attributes they will have will be defined as well as which keys will be used as primary key and foreign keys. With this information I will then develop the relationships between the entities. The Investigator Entity will contain have the following attributes; Assigned Case Number, Investigator Last Name, Investigator Employee Number, Case Title (Charged Offense), Date Exam Requested and Number of Devices Submitted for Examination. The Suspect Entity have the following attributes; Assigned Case Number, Suspect Last Name, Suspect First Name, Suspect Date of Birth, Case Title (Charged Offense) and Case Disposition. The Forensic Examiner entity will have the following attributes; Assigned Case Number, Date Case Assigned, Date Case Completed and Number of Devices Examined. The primary key and the foreign key will be the Assigned Case number for all entities.
Physical
At the physical level the tables will start to take shape as the entities are formed into tables. The columns of the tables will be defined by the attributes previously determined. Foreign keys will show the relationships between the entities. During this phase of developing my data base I will start to build the tables that will make up the entities noted above and develop the relationships between the tables using the foreign key, for this database that will be the Assigned Case Number.

Implementation At this phase of the design process a working model will be created from the entities developed during the design phase. At this phase I will build a working model of the case management database on a single workstation.
Data Loading During the Data Loading phase sample data will be loaded into the database model. Data for this database
Show More

Related Documents: Database Design Life Cycle Essay

Fundamentals of Database Systems Key Assignment Essay examples

Project Fundamentals of Database Systems CS251-1202B-03 June 25, 2012 Table of Contents Project Outline 4 Description of the Database Design Life Cycle (Phase 1 IP) 4 Selected Database Description 4 Tablet and Capsule Antibiotics 4 Powder and Liquid Antibiotics 5 Skin and Coat 5 A Listing And Description Of The 7 Steps Of The SDLC/DBDSL and Their Tasks 6 System Requirements Analysis and Feasibility Study 6 System Analysis 7 Code Generation and Design 9 Implementation 9…

Words 3571 - Pages 15

Cs251 Fundamantals of Database Systems Ip 1 - 5 Essay

CS251-1301B-03 Fundamentals of Database Systems Phase 1 -5 Individual Project Robert March 24th, 2013 Table of Contents Project Outline 3 Description of the Database Design Life Cycle 4 The Entity Relationship Diagram 7 The Logical Model and Normalization 9 The Microsoft Access Database 11 The Microsoft Access Database Application 14 References: 18 Project Outline My idea for a project concept is for a granite fabrication and installation company called MasterStoneWorks…

Words 1684 - Pages 7

What Is Organizational Impact

manufacturing and the service industry and how innovation, design and creativity affect the organizations. A manufacturing industry is an organization that produces intangible and tangible products. For example the Chrysler Company produces the Concorde automobile that is designed by a team of management. The design team is in charge of making tangible and intangible products. The products that are produced are for different types of skill sets and designs. The Chrysler Concorde has 10,000 unique parts, the…

Words 776 - Pages 4

1st Coursework For Facilities Management Essay

Planning, Architecture and Civil Engineering Queen’s University Belfast Table of Contents 1. Introduction 2 2. Literature Review 3 2.1. Early FM Involvement 3 2.1.1. The benefits of the involvement of FM in the design process 3 2.1.2. The barriers of the involvement of FM in the design process 4 2.2. Benchmarking 4 2.2.1. The benefits of the benchmarking 5 2.2.2. The barriers of the benchmarking 5 3. Further Discussion 6 4. Conclusion 8 5. References 9 The Added Value of Facilities Management:…

Words 2512 - Pages 11

Nt1310 Unit 3 Assignment 1

E. Constraints a. Control functions The application should be able to demonstrate the refreshed data on the site, immediately if there should an occurrence of changes made to the database. The database for the project is intended to be of direct size For the most part, the application is intended to have the capacity to keep running in Internet Explorer. The Airline Reservation framework will be composed such that, it can keep running on a Windows server. Users need to introduce/run Internet Explorer…

Words 1412 - Pages 6

Fundamentals of Software Testing Essay

ingd1. Overview The Big Picture All software problems can be termed as bugs. A software bug usually occurs when the software does not do what it is intended to do or does something that it is not intended to do. Flaws in specifications, design, code or other reasons can cause these bugs. Identifying and fixing bugs in the early stages of the software is very important as the cost of fixing bugs grows over time. So, the goal of a software tester is to find bugs and find them as early as possible…

Words 8345 - Pages 34

Essay on Building Information Modelling

Wikipedia (2014), Building Information Modelling (BIM) is a process of digitally represent the physical and functional characteristics of an infrastructure during its life-cycle, as a reliable basis for making decisions based on the cooperation between different stakeholders in exchanging the knowledge at different stages of the life-cycle of the infrastructure. 1.2. Background As a type of advanced construction tool, BIM plays a significant role in the Green Building construction and has a series…

Words 1193 - Pages 5

bsa375 wk1 Essay

SDLC Planning Analysis Phase Design System construction Installation process Support plan Planning Analysis Design Implementation Understand why a information system is needed Develop an analysis strategy Define the requirements Create a system proposal Design strategy Architecture design Database and file design Program design Implementation Phase The System Development Life Cycle Conclusion By carefully following the four phases of the system development life cycle and the steps defined in each…

Words 389 - Pages 2

Online Reservation System Essay examples

far by the use of Internet websites and online reservation systems, gives competitive advantage to other with same establishment. However, the potential competitive advantage can be transformed into real advantage if only the websites have proper design. As a result, the advocator conducted research on the facts related to the system that might be helpful to its development. The following are the gathered related proposed system: Jeong et al. (2005) discuss the role of website quality in attracting…

Words 3773 - Pages 16

Business Information Systems Essay example

Business Information Systems Business Information Systems ASSIGNMENT ASSIGNMENT TABLE OF CONTENTS INTRODUCTION PAGE 1 BODY-QUESTION ONE 1.1 PAGE 2&3 1.2 PAGES 1.3 PAGES QUESTION TWO 2.1 PAGES 2.2 PAGES 2.3 PAGES QUESTION THREE 3.1 PAGE 3.2 PAGE 3.3 PAGE 3.4 PAGE CONCLUSION PAGE REFERENCE PAGE Introduction…

Words 6871 - Pages 28