|
|
|
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 3 The relational database software comes to the rescue again by making data entry easy. The software knows that you're working on more than one file at a time and that the files have related information, for example, it knows that each patron name in the intersection file, will have a match in the patron file. Therefore, the software sets up your data entry so that you only have to type in the information once and it automatically copies the info that you typed to the related files. But because the software knows what you're up to, it can do some other very helpful things. For example, let's say you mistyped Andrew's name (maybe you typed "Andy" by mistake) while adding a record to the intersection file. The software would see that there's no "Andy" in the patron file and give you a warning. This greatly cuts down on errors. Same thing if you were typing in a book a patron was checking out and you misspelled the book name. The software would tell you "That book doesn't exist in the book file!" Remember that Andrew's (or any patron's) address only appears once, and that's in the patron file. So if Andrew moves, his address information only has to be updated one time in one place, and no matter how many books he checks out, his address will always be current. 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.
|
