PDA

View Full Version : Theory and practice of database design

Pages : 1 2 [3] 4 5
  1. relationship/table prob
  2. database design to preserve history
  3. Store a history of data
  4. Database to hold scripts
  5. Help needed with relational database
  6. Special Characters / Foreign Languages
  7. join tables
  8. Inventory Purchasing Aid
  9. Stumped on book db structure
  10. Database Replication
  11. Distributing my application
  12. Database Relationship Loops
  13. MS-Access into Outlook - possible?
  14. normalisation
  15. initial database design help
  16. New Database
  17. Confused on which schema is correct!!
  18. Combining two separate databases
  19. forms and tables
  20. A fishy problem
  21. Access frontend
  22. Table(s) with 100s of Serial Numbers?
  23. Design Conundrum
  24. How to handle several tables with similar content?
  25. Correct Table Structure?
  26. ERD Diagram, splitting data into separate table?
  27. Merging Tables with Duplicate ID's??
  28. Best way to do this?
  29. urgent db design problem
  30. Handling Alias relationships
  31. Inventory Management Database
  32. Error Trapping between Forms
  33. Using Single or Multi Databse For Each Year ?
  34. Regular Reporting Dilemma
  35. A lot of tables or lots of spaces?
  36. Sample of Good GUI Design Databases
  37. Normilisation help
  38. design issue
  39. Best Practice: String or Number For Auto ID
  40. parent-child-grandchildren..
  41. Bulk Order Database?
  42. Design process for a beginner
  43. Multiple 'databases' within one db
  44. Main Table design, storage of FKs
  45. User Logins to Drill Down to Access Lower Levels
  46. Too Many Relationships ?
  47. RFID Automatic Multiple Data Entry Question
  48. keeping running totals vs. calculating
  49. newbie question
  50. Is the following possible in Access?
  51. Single table vs Two views...
  52. help my normilisation
  53. Self Joins: Query Window Versus Relationships Window
  54. A database structure conundrum...
  55. seperate table or one table to hold all the drop down options?
  56. Remember Variables After Database Exit
  57. Query Best Practices
  58. time calc. question
  59. 2 developers working on the same database
  60. Split database: Can you have different front ends?
  61. Making my design feasible
  62. Which Database Design book is the best for me?
  63. Archive Record vs. Filter it Out
  64. Flight Reservation Database Ideas?
  65. Normalisation help needed please for Contact section of DB
  66. Simple Import Malfunction
  67. Copy tables and relationships w/o Data
  68. Segragation of duties??
  69. Can someone tell me if this makes sense
  70. The Larger of the Two Table Making Evils?...
  71. Project Management db.
  72. Order DB
  73. Suggestions for Name Algorithm
  74. Handle NotActive records
  75. Linking tables
  76. Replacement of Inventory Item
  77. Crazy Report Design Issue
  78. Tracking intermittent membership
  79. How can prevent the access files are copied ?
  80. Moving Inventory to 2 different location
  81. normalizing data
  82. Demo DB on CD
  83. Access Automatically Creating Relationship I don't want
  84. Can someone tell me if this is possible..?
  85. Database design
  86. Where to start... food industry Access Database
  87. Database Design question
  88. Database design and concept
  89. Unenforced relationships in Access --> SQL Server
  90. Database Replication Problem
  91. Creating a database (noob)
  92. Can someone help about database design?
  93. Adding multiple locations to an existing database
  94. Complex Database - Customers, Property, Ownership, Invoices, and Payments
  95. why split database?
  96. Normalize Lookup Tables??
  97. connecting other Databse using access
  98. create linked tables
  99. Creating relationships & PKs/FKs with linked tables
  100. Oops..I used lookup tables
  101. Design Question, location change
  102. Database Design Optimization - can somebody check it out, please?
  103. Travel Itinerary Database
  104. Store by region or country, search by postcode
  105. Database design assistance needed
  106. Table Look-Ups
  107. Database Design Help
  108. Database Design (Work hours log)
  109. Massive Frontend
  110. New Database Help
  111. Seeking Enlightenment
  112. cataloguing database
  113. inventory
  114. Displaying data in specific format
  115. Your favorite database idea
  116. Ideas on Double approval process
  117. implementing restructuring in a database
  118. Network Problem Work-A-Rounds
  119. Weekly Production Tracking Database
  120. Speed? Linked Tables?
  121. Worth Splitting database?
  122. Computer and Software Database Design
  123. Design a database for animals in many lakes
  124. OLAP Cubes in Access (multidimensional dataset)
  125. Service Database with endless order types to enter/track/invoice/etc.
  126. New to DB's - Structure Q
  127. Pks
  128. Database Project ~ Help/Advice needed ~
  129. Discussion on transaction storage (accountant and DBA input welcome)
  130. Time to Archive?
  131. New database - help needed with Tables and Relationships please?
  132. Database Security
  133. simple inventory and people checkin/out
  134. delete a database file
  135. Online access?
  136. Normalisation, referential integrity
  137. Sharing Access Database
  138. Expert needed!!!
  139. New database ... how to best structure it!?
  140. Preventing navigation
  141. Normalising time-share vs full-time occupants
  142. Validity period as key attribute possible?
  143. Frontend / Backend Question
  144. Contract Database and Invoice Troubles
  145. Null fields in Unique Idx
  146. Designing stock DB
  147. To Union or Not, that is the question that preoccupies us.
  148. Ol' School bypass trick for system time
  149. log table
  150. Error with "cascade update related field". Unable to change field.
  151. PKs, FKs, Candidate Keys and teasing apart an already populated master table
  152. Two Tables With Two Joins?
  153. Most effective joins
  154. Naming Conventions, a Discussion
  155. More Questionnaire Advice Pls?
  156. Your opinion on ADP
  157. Integrated/shared MS database
  158. Make table query against a normalizing select query.
  159. Bring data together from several databases
  160. db Maintenance...sweeper
  161. Question about table access
  162. the Many to many problem
  163. Opinions on slick ways to design database
  164. Application for Multiple Databases
  165. Show only the access program
  166. Comparing data storage
  167. Logic For Access Program
  168. Avco
  169. DB design help
  170. check design / offer suggestions ?
  171. Access or Not
  172. Inventory and Invoicing Philosophy
  173. Training Tracking DB
  174. Documenting database
  175. Normalization to 3NF
  176. Help neede on database design
  177. Client / Server design in a 100MB database.
  178. This is a serious ERD problem...
  179. do i create 12 tables for 12 forms or one table
  180. how to identify a weak entity ?
  181. Round robin survey design
  182. Using an "IsVisible" field
  183. ERD help!
  184. access 2007 accdb database frontend and forms
  185. "User-Friendliness"
  186. Open to criticism...
  187. Help with Database design
  188. Access 2007 as Frontend, SQl Server 2005 Express as Backend
  189. Checkboxes and Normalization
  190. OLAP versus data warehousing
  191. Storing lots of NULL values
  192. Order Intake DB
  193. Please help with normalisation
  194. Basic Help
  195. Help with database design please!
  196. Better to keep all tables in the same database (be vs. fe)?
  197. How to calaulate?
  198. Complex Database Design
  199. Productivity Database- Determining whats Pending
  200. Basic structure question
  201. Normalization HELP! - Simple Question
  202. Designing a database for blood donors
  203. Stored Calculations
  204. Project size conundrum - field limits in tables
  205. Normalization For Family Groups
  206. Multiple one to many joins between two tables?
  207. For creation of frieght bill depending on the route
  208. Ugandan coffee growers survey
  209. Relate And/Or Fields in DB Design
  210. split a table into two
  211. Need help with database concept
  212. Yet another stock/inventory control thread
  213. ACCESS 2003 : Linking OLE Objects
  214. Cleaning up a database?
  215. Reasonable time between updating front ends
  216. Help/Tips - Design of database to log/track vandalism at work
  217. Tree Structure
  218. Tips for speeding up FE/BE database?
  219. Using Northwind DB template and modifying but getting errors
  220. Table Design questions
  221. reports on added records not appearing
  222. Why cant we just get along...
  223. Best design for Access 2003 FE/ sql BE. Need critiques
  224. International Shipping Company Database Design.
  225. Is Access Good Enough for Retails?
  226. Non-primary keys in relationships
  227. Query results exceed "clipboard" limit of 64K records
  228. Query results exceed "clipboard" limit of 64K records
  229. Help Needed
  230. I'm stuck - DB Design problems
  231. Some help with my Normalization please
  232. The dreaded question about questionnaire database
  233. Best Dev Software?
  234. Help/Advice Needed for my Dissertation Please!
  235. Civil Jobs tracking database in 2003
  236. normalization with a twist-plz help
  237. Help in designing a simple office database
  238. Please critique my proposed method of replication
  239. Completing Module and marco
  240. SQL Server on Local Drive - A Few ???
  241. QA requested
  242. Relationships between tables
  243. course attendance and expiration table design
  244. Newbie question
  245. How would you design a db...
  246. Serious slow down issues Access 2003
  247. Normalization for checkboxes?
  248. Images in database Access 2007
  249. Keep Access Open Question
  250. Help with design