Beginning Database Design Solutions
The vast majority of software applications use relational databases that virtually every application developer must work with. This book introduces you to database design, whether you're a DBA or database developer. You'll discover what databases are, their goals, and why proper design is necessary to achieve those goals. Additionally, you'll master how to structure the database so it gives good performance while minimizing the chance for error. You will learn how to decide what should be in a database to meet the application's requirements.
What people are saying - Write a review
We haven't found any reviews in the usual places.
Other editions - View all
Access allow anomalies application Atomic Transactions attributes backup build business rules candidate key Chapter check constraints clause column command course CREATE TABLE customer record customer's CustomerId data type database design database's define DELETE described diagram dimensional database employee entity entityrelationship example exercise solutions fields FirstName foreign key constraints hierarchical database identify implement INSERT inthe InventoryItems LastName lookup table manytomany relationships MySQL MySQL Workbench needto Normal Form NULL ofthe onetomany relationship OrderId OrderItems Pampered Pet password perform PersonId Pet case study phone number primary key Query Browser relational databases relational model represent rows script SELECT semantic object model shown in Figure shows ShowTimes statement superkey table's primary key thedatabase Third Normal Form transaction UPDATE user interface valid values verify weak entity youcan