Acknowledgements
Adrienne Watt This book has been a wonderful experience in the world of open textbooks. It's amazing to see how much information is available to be shared. I would like…
About the Book
Database Design - 2nd Edition is a remix and adaptation based on Adrienne Watt's book Database Design. Works that are part of the remix for this book are listed at the end…
Appendix C SQL Lab with Solution
Download the following script: OrdersAndData.sql. Part 1 – DDL Use the script OrdersAndData.sql that creates the tables and adds the data for the Orders and Data ERD in Figure C.1.…
About the Authors
Primary Author: Adrienne Watt Adrienne Watt holds a computer systems diploma (BCIT), a bachelor's degree in technology (BCIT) and a master’s degree in business administration (City University). Since 1989, Adrienne…
Appendix B Sample ERD Exercises
Exercise 1 Manufacturer A manufacturing company produces products. The following product information is stored: product name, product ID and quantity on hand. These products are made up of many components.…
Appendix A University Registration Data Model Example
Here is a statement of the data requirements for a product to support the registration of and provide help to students of a fictitious e-learning university. An e-learning university needs…
Preface
The primary purpose of this text is to provide an open source textbook that covers most introductory database courses. The material in the textbook was obtained from a variety of…
Hello world!
Welcome to BC Open Textbooks. This is your first post. Edit or delete it, then start blogging!