|
|
|
Free
Database Design for Mere Mortals : A Hands-On Guide to Relational Database Design
Relational Database Design for Mere Mortals explains the concepts of relational-database design in an easy-to-digest fashion that covers both the theoretical underpinnings and their practical implications. Hernandez covers all the basics--table and field structure, keys, relationships, business rules, and more--but always keeps his feet on the ground with advice for real-world implementations and a particularly strong section on analyzing your current database infrastructure. Designing
Relational Database Systems |
Free Relational Database Tutorial and Tips For Beginners!Intro To Data ModelingLesson 1 Most novices approach creating data files as though they are typing a list on a piece of paper. For some situations this works. Spread sheets for simple problems are good for this. Here's an example where a simple file is sufficient: you want an inventory of all the valuables in your house. It could look something like this:
This is good and valid. Let's look at another situation. You are hired to manage the records for a new library. For convenience of illustration, let's say that there's only a few patrons, each with a unique name and a few books. So, you get your trusty spread sheet out and set up a single file that looks like this:
It works! Now the library can keep track of who checked out what books and when! But look a little closer. Andrew checked out two books, Tennis! and Soccer! Notice that you had to type in Andrew's address twice. Bummer! Now if Andrew checks out 20 books, you'll have to type in his whole address 20 times! Redundant! Ugh! What's just as bad is what if Andrew changes his address and moves across the street from where he used to live. Then you have to update the addresses on all 20 records! More bad news, every time you type in a book, you have to type in the author's name. Somehow, our beautiful single file system has gotten out of control. There must be a better way. Enter the relational database. It can handle this messy situation cleanly! Click here to continue Data Modeling Essentials : Analysis, Design, and Innovation 
An innovative "how-to" guide and design aid to data modeling. This book
discusses the theory and practice of data modeling as a design activity,
and shows the reader how to increase quality and stimulate creativity with
new modeling approaches. The book is useful as both a basic learning tool,
and a thought provoking guide to higher achievement in designing and executing
data models.
Data Modeling for Information Professionals 
Explains to members of a project team creating an information system, especially
a computerized system, how to structure data. Discusses such aspects as
what data models are, what makes them successful and fail, the components
of an enterprise data model, domains, predicates, entities, classes, relationships,
and attributes. The CD-ROM contains two full-function CASE repositories
developed during the redesign of a travel tour company.
|
