Six-step Relational Database Design: A Step by Step Approach to Relational Database Design and Development

Front Cover
Fidel A Captain, May 11, 2013 - Computers - 232 pages

Six-Step Relational Database DesignTM bridges the gaps between database theory, database modeling, and database implementation by outlining a simple but reliable six-step process for accurately modeling user data on a Crow's Foot Relational Model Diagram, and then demonstrating how to implement this model on any relational database management system.

The second edition contains a new chapter on implementation that goes through the steps necessary to implement each of the case studies on a relational database management system, clearly relating the design to implementation and database theory. In addition, questions are also included at the end of each of the six steps and one of the previous case studies has been replaced, making the case study selection more diverse.

Six-Step Relational Database DesignTM uses three case studies and starts with a statement of the problem by the client and then goes through the six steps necessary to create a reliable and accurate data model of the client's business requirements. This model can then be used to implement the database on any relational database management system.

Six-Step Relational Database DesignTM should be used as a handbook for students and professionals in the software-development field. The technique described in this book can be used by students for quickly developing relational databases for their applications, and by professionals for developing sturdy, reliable, and accurate relational database models for their software applications.

 

Contents

Definition and History
2
Terms used in relational database design and development
4
Relational Database Design
5
Review Questions
12
Exercises
13
Discover entities and assign attributes
16
Summary
33
Review Questions
35
Review Questions
90
Exercises
91
Transform the detailed ER diagram into an implementable RM diagram
94
Summary
131
Review Questions
134
Exercises
135
Case Study 1
138
Case Study 2
142

Exercises
36
Derive unary and binary relationships
38
Summary
47
Review Questions
48
Exercises
49
Create simplified EntityRelationship diagram
52
Summary
61
Review Questions
62
Exercises
63
List assertions for all relationships
66
Summary
74
Review Questions
75
Exercises
76
Create detailed ER diagram using assertions
78
Summary
89
Case Study 3
148
Summary
155
Review Questions
158
Exercises
159
Relational Database Management Systems RDBMSs
162
Normalization
166
Indexes
171
Data Types
174
Implementation of Case Study Designs
178
Summary
200
Review Questions
202
Exercises
203
References
205
Index
207
Copyright

Other editions - View all

Six-Step Relational Database Design(tm): A Non-Theoretical Approach to ...
Fidel A. Captain
Limited preview - 2012

Common terms and phrases

AccessLevelCode AccessLevels AddressLinel assertions cardinality CASCADE ON DELETE client column Computerld Computers CourseDescription CourseId CREATE TABLE Crow's Foot R-M database management system database transaction DateReceived DEFAULT NULL DELETE RESTRICT detailed E-R diagram diagram below shows E-E Matrix Employees EndDate entity discovered entity occurrence Foot R-M diagram foreign key HTel identifiers implemented INDEX Itemld JobNum LaborCost LastName FirstName Lecturers length character string LogEntries LoggedOff LoggedOn Login many-to-many many-to-many relationships MaximumSalary MiddleName MySQL NULL AUTO_INCREMENT NULL DEFAULT NumlnStock old relationship one-to-many one-to-many relationships optionality:cardinality PartNum Payments PK CourseCode PK Customerld PositionDescription PositionName PostCode primary key problem domain RDBMS RDBMSs referential integrity relational database design Relational Model Relations and relationships relationship diamond RepairJobs Repairmen Repairmenld SalaryScaleCode SalaryScaleName SalaryScales ScheduleCode ScheduleOfClasses second normal form Semesterld SemesterNumber Semesters SemesterYear SerialNum ShortName simplified E-R diagram six-step process SSNumber StartDate Step Study third normal form TotalCost UPDATE CASCADE UserId UserName Users WTel

About the author (2013)

Fidel A. Captain has over 15 years of experience designing, implementing, and maintaining databases, and over 10 years of experience as a lecturer. He has worked as a systems analyst and systems engineer with the Ministry of Finance in Guyana, as a computer studies lecturer at the H. Lavity Stoutt Community College in the British Virgin Islands, and as a freelance consultant. Captain has developed several database-based applications that include an online bill payment system, a logistics and cargo tracking system, a student tracking and evaluation system, and a freight and duty calculation system. Captain is a Queen's College Guyana Scholar, who received his Bachelors of Engineering Degree from the University of Manchester Institute of Science and Technology in Computer Systems Engineering, and a Master's in Information Technology from Capella University. He is also a certified MySQL developer and administrator.

Bibliographic information

TitleSix-step Relational Database Design: A Step by Step Approach to Relational Database Design and Development
AuthorFidel A. Captain
PublisherFidel A Captain, 2013
ISBN1481942727, 9781481942720
Length232 pages
Subjects ›  › 

Computers / Computer Science
Computers / Data Science / Data Modeling & Design
Computers / Database Administration & Management
  
Export CitationBiBTeX EndNote RefMan