JayBeeOH

SampleDB Database (SampleDB.accdb)

Jul 13th, 2015
368
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.49 KB | None | 0 0
  1. ' Notice of My Copyright and Intellectual Property Rights
  2. '
  3. ' Any intellectual property contained within the program by Joseph L. Bolen remains the
  4. ' intellectual property of the Joseph L. Bolen. This means that no person may distribute,
  5. ' publish or provide such intellectual property to any other person or entity for any
  6. ' reason, commercial or otherwise, without the express written permission of Joseph L. Bolen.
  7. '
  8. ' Copyright © 2015. All rights reserved.
  9. ' All trademarks remain the property of their respective owners.
  10. '-------------------------------------------------------------------------------------------
  11. ' Name: SampleDB Database (SampleDB.accdb)
  12. '
  13. ' Author: Joseph L. Bolen
  14. ' Date Created: Jul 2015
  15. '
  16. ' Description: Simple MS Access Database two table schema.
  17. '
  18. ' Documentation is at:
  19. ' App's Visual Basic .NET code is at: http://pastebin.com/17cmsw1h
  20. ' Video tutorial at YouTube: http://www.youtube.com/user/bolenpresents
  21. '------------------------------------------------------------------------
  22.  
  23. Customers Table-
  24. Name Type Size
  25. CustomerId (PK) AutoNumber
  26. CustomerName Text 35
  27. CustomerContact Text 35
  28. Phone Text 15
  29.  
  30. Orders Table-
  31. Name Type Size
  32. OrderId (PK) AutoNumber
  33. CustomerId (FK) Number Long Integer
  34. OrderDate Date/Time
  35. OrderQuantity Number Long Integer
  36.  
  37. Relationship: Customers (CustomerId) to Orders (CustomerId)
  38. Relationship Type: One-To-Many
Advertisement
Add Comment
Please, Sign In to add comment