|
More site info...
Theory and practice of database design | Forum profile
|
|
Forum profile page for Theory and practice of database design on http://www.access-programmers.co.uk.
This report page is the aggregated overview from a single forum: Theory and practice of database design, located on the Message Board at http://www.access-programmers.co.uk.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "Theory and practice of database design" on the Message Board at http://www.access-programmers.co.uk is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on Theory and practice of database design:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
23
|
56
|
164
|
|
Post:
|
64
|
191
|
558
|
|
|
Theory and practice of database design Posting activity graph:
|
Top authors during last week:
user's latest post:
This is a serious ERD problem......
Published (2009-11-06 15:15:00)
Just some theoretical musing anyway. As long as you are careful about changing your PK, have fun. I just dislike it because it has some interesting side effects if you are keeping strict audit trails. Perhaps that is why I take the view that I do. If you are in an environment where you have strict auditing requirements (such as the USA Dept. of Defense, where I work), you CANNOT change a PK if doing so would invalidate historical auditing...
user's latest post:
"User-Friendliness"
Published (2009-11-06 09:11:00)
I "wish" I could get this place to update, but we're in the stone ages on way too much here and the old guard stomps their feet and cries bloody murder anytime a change is suggested. Hell, we don't even have a server.. we're on a peer to peer network. That causes more headaches than anything. Thank you for the link on the explorer bar... I'll take a look.
user's latest post:
Help with Database design
Published (2009-11-10 09:33:00)
I would use Access for this. In your design, I would put all people in a single table. This means employees and customers. About calculating the workdays, see: Add work days and calculate net work days
user's latest post:
Access 2007 as Frontend, SQl...
Published (2009-11-09 22:31:00)
I don't think you can address the Excel session on your PC from the TS session. However you could export the Access data to an Excel file and then open that with the local Excel application. You could also use an ODBC connection to the SQL Server from Access. If you are not actually processing the data from the spreadsheet you would no be risking the integrity of the data on the server by just reading it. The same would apply to the FE...
user's latest post:
Checkboxes and Normalization
Published (2009-11-10 04:08:00)
Quote: Originally Posted by DCrake In your current form layout you are using checkboxes to denote the accreditation type if you chang ethis to an option group. Thus preventing more than one accreditation type being selected this should not mess up your form layout. The problem we run into is that facilities can have multiple accreditations. I might be missing something in your explanation, but I think the allowance of multiple accreditations...
user's latest post:
Access 2007 as Frontend, SQl...
Published (2009-11-09 22:15:00)
Well, I my specific case Access copies via VB some values into different Excel Sheets. Will VB adress the local Excelapplication or will it stay within the Terminal Server?
user's latest post:
OLAP versus data warehousing
Published (2009-11-12 12:39:00)
A Data Warehouse is a database that is subject-oriented (rather than designed to service an application), time-variant, integrated (presents a single consistent view of the enterprise) and non-volatile. Data Warehouses are a central component of most Business Intelligence solutions. OLAP is a type of technology also used in Business Intelligence, frequently in conjunction with a Data Warehouse.
user's latest post:
access 2007 accdb database...
Published (2009-11-04 08:57:00)
Thanks for the help. I'll look at the trust/file folder permissions. With hindsight that could be an issue as I'm not sure the 2nd machine I was trying out the front end on has write access to that network folder... In the meantime I have been working on the backend as a standalone. There are only a dozen or so tables but the whole database bloated out to over 109mb in size.. I ran repair and it came down to just over 1mb. .....
user's latest post:
Open to criticism...
Published (2009-11-06 12:53:00)
thanks, I will read up on the website george suggested. for clarity, there is only one category table where the PK in that table is referenced by two different FKs in the org table and ditto for subcategories. Thanks for the ID advice in the cat type table. The reason I started this thread was because I am trying to normalize the org table and am trying to figure out whether it is worth it/good idea to separate out the address fields into new...
|
|
|
|
Latest active threads on Theory and practice of database design::
Started 1 day, 14 hours ago (2009-11-13 13:19:00)
by wiklendt
one giant table with lots of nulls will take up space - lots of it. it will also not only slow down your queries but cause them to be VERY PAINFUL (and sometimes impossible, depending on the complexity of the results you want) to create in the first instance.
what you need to do is "normalize" your data - you need a client table, a MedicalRecords table (with a ClientID in it to match them up) ...
Started 4 days, 17 hours ago (2009-11-10 09:33:00)
by HiTechCoach
I would use Access for this.
In your design, I would put all people in a single table. This means employees and customers.
About calculating the workdays, see:
Add work days and calculate net work days
Started 1 month, 2 weeks ago (2009-09-26 21:54:00)
by wiklendt
i guess that would depend on what you want to do. as a somewhat novice myself, i would say the best place to STORE data is in a table, as for the other options you gave, this is my understanding of each ( as a novice , remember!):
forms are used for data entry and data display, not for storage - they display/enter data already in a table or send data TO a table;
tags aren't so much data...
Started 3 days, 16 hours ago (2009-11-11 10:39:00)
by georgedwilkinson
I assume you just want general discussion on this since just about anybody can do a quick google and get more than we could possibly type here.
Data warehousing is this whole nebulous field of managing decision support data. OLAP is a sub-category of data warehousing. In my mind, OLAP is the sibling to OLTP which is where normalization is so important.
Does that help? I'm sure other ...
Started 1 month ago (2009-10-13 13:29:00)
by Kryst51
I have a program on my comp called Concept Draw Web Wave, it might be
useful, I have seen one use of this software to show a database's design
with links, table relationships, etc, plus you can add text boxes, etc. I
haven't had time to delve into the program, I believe you can also link to
a database and import your table setup into it. This was suggested to me to
use for documentation as you ...
Started 5 days, 7 hours ago (2009-11-09 19:40:00)
by georgedwilkinson
You're right, it is not properly normalized.
Think about it in a business sense. The word "Primary" is not a business word, nor is Secondary or Tertiary. As such, they should not be used for database object names.
An example of how to straighten this out is to create a couple of more tables and move some of the columns from the existing tables:
tblFacilities: stores facility ...
Started 5 days, 8 hours ago (2009-11-09 18:40:00)
by Galaxiom
Run the FE via Terminal Services over the VPN rather than simply running on
the remote machine. Then just the keystroke and mouse movements are
transmitted and the screen updates received. This is faster and much more
reliable because the FE is running on the server and doesn't half do a task
if the Internet connection fails.
Started 1 month, 1 week ago (2009-10-08 08:55:00)
by dportas
How would you produce a Balance Sheet and a P&L without a double entry ledger? You would still need some way of mapping each transaction item to Balance Sheet codes and P&L codes. It seems like the "obvious" way to do that in a database is with two or more row(s) in a table (or possibly tables).
Quote:
Originally Posted by GalaxiomAtHome...
Started 1 week, 1 day ago (2009-11-06 12:20:00)
by georgedwilkinson
You have several problems. Take a look at: http://www.tdan.com/view-articles/5014 for a good discussion on normalizing Organizations. Duplicate the logic there for the rest of your model.
Post back here with specific questions once you understand that.
Started 1 month ago (2009-10-14 23:21:00)
by namliam
well a department is a department, I dont see "logistics department" or "IT Department" as seperate, but as one... Department.
Same with people/employee's you dont make "managers" "developers" "account managers" etc for each function, you just have "employee"
Same thing with Assessments or fora or what ever, Perhaps some are different in requirements but most can probably be captured ...
|
|
Hot threads for last week on Theory and practice of database design::
Started 5 days, 7 hours ago (2009-11-09 19:40:00)
by georgedwilkinson
You're right, it is not properly normalized.
Think about it in a business sense. The word "Primary" is not a business word, nor is Secondary or Tertiary. As such, they should not be used for database object names.
An example of how to straighten this out is to create a couple of more tables and move some of the columns from the existing tables:
tblFacilities: stores facility ...
Started 5 days, 8 hours ago (2009-11-09 18:40:00)
by Galaxiom
Run the FE via Terminal Services over the VPN rather than simply running on
the remote machine. Then just the keystroke and mouse movements are
transmitted and the screen updates received. This is faster and much more
reliable because the FE is running on the server and doesn't half do a task
if the Internet connection fails.
Started 1 week, 2 days ago (2009-11-05 08:15:00)
by Atomic Shrimp
As long as the application is a fairly simple one, I've recently taken to creating it all in one form with a tab control - and instead of having separate little forms, each distinct function of the application has its own tab. That way, you don't have to worry about what happens if they manage to close the switchboard and get stranded in one of the satellite forms, or if one form is obscured by ...
Started 1 week, 1 day ago (2009-11-06 12:20:00)
by georgedwilkinson
You have several problems. Take a look at: http://www.tdan.com/view-articles/5014 for a good discussion on normalizing Organizations. Duplicate the logic there for the rest of your model.
Post back here with specific questions once you understand that.
Started 4 days, 17 hours ago (2009-11-10 09:33:00)
by HiTechCoach
I would use Access for this.
In your design, I would put all people in a single table. This means employees and customers.
About calculating the workdays, see:
Add work days and calculate net work days
Started 3 days, 16 hours ago (2009-11-11 10:39:00)
by georgedwilkinson
I assume you just want general discussion on this since just about anybody can do a quick google and get more than we could possibly type here.
Data warehousing is this whole nebulous field of managing decision support data. OLAP is a sub-category of data warehousing. In my mind, OLAP is the sibling to OLTP which is where normalization is so important.
Does that help? I'm sure other ...
Started 1 day, 14 hours ago (2009-11-13 13:19:00)
by wiklendt
one giant table with lots of nulls will take up space - lots of it. it will also not only slow down your queries but cause them to be VERY PAINFUL (and sometimes impossible, depending on the complexity of the results you want) to create in the first instance.
what you need to do is "normalize" your data - you need a client table, a MedicalRecords table (with a ClientID in it to match them up) ...
Started 1 month, 1 week ago (2009-10-08 08:55:00)
by dportas
How would you produce a Balance Sheet and a P&L without a double entry ledger? You would still need some way of mapping each transaction item to Balance Sheet codes and P&L codes. It seems like the "obvious" way to do that in a database is with two or more row(s) in a table (or possibly tables).
Quote:
Originally Posted by GalaxiomAtHome...
Started 1 month ago (2009-10-13 13:29:00)
by Kryst51
I have a program on my comp called Concept Draw Web Wave, it might be
useful, I have seen one use of this software to show a database's design
with links, table relationships, etc, plus you can add text boxes, etc. I
haven't had time to delve into the program, I believe you can also link to
a database and import your table setup into it. This was suggested to me to
use for documentation as you ...
Started 1 month ago (2009-10-14 23:21:00)
by namliam
well a department is a department, I dont see "logistics department" or "IT Department" as seperate, but as one... Department.
Same with people/employee's you dont make "managers" "developers" "account managers" etc for each function, you just have "employee"
Same thing with Assessments or fora or what ever, Perhaps some are different in requirements but most can probably be captured ...
|
|
Size: 834 bytes
