Current Position:Home > Data base lay out

Data base lay out

Update:11-30Source: network consolidation
Advertisement
hi i have a data bas that i think is layed out in the best way thank i can think of normalised and all that.
how would i know if the way that i and doing things is the best it work fine but good programming is allways better.
how could i repersent the lay out of my data bases. am using MS Access. thanks

The Best Answer

Advertisement
If you're asking the chances that your data are optimally (or indeed correctly) laid out are slim.
I'd recommend this book:
http://www.amazon.com/exec/obidos/tg/detail/-/1558604324
And then I'd recommend another ten to twenty years experience. At which point you might be able to say "I think my schema is probably reasonably correct".
  • Data base lay out Update:11-30

    hi i have a data bas that i think is layed out in the best way thank i can think of normalised and all that. how would i know if the way that i and doing things is the best it work fine but good programming is allways better. how could i repersent th

  • Transfer of xml file elements to data base columns Update:10-11

    hi all, i have to store xml file's data(element values) into the data base(table columns). i heard that we can acheive this by XSU. IS it is mediator between xml and db? if yes how to install it. i tried something as below with t as ( select xmltype(

  • How to export a data as an XML file from oracle data base? Update:10-11

    could u pls tell me the step by step procedure for following questions...? how to export a data as an XML file from oracle data base? is it possible? plz tell me itz urgent requirement... Thankz in advance BalaSQL> SELECT * FROM v$version; BANNER Ora

  • Can any one help me to configure the mysql table to enable user expiration to function, I have tryed most things, but not dates are being passed back to the data base from the form Update:10-11

    Im trying to build  user expiration into my registration form, but I cant get the form to send back the date registering. in my data base i have tried every thing from timestamp to datetime. I can get a timestamp but it is not functioning with the ex

  • Quota Generation not happen's on Pro data basis . Update:10-11

    Dear experts, Time evalution status - 1. 1.Employee service 0 - 5 years - 24 Days entitlement 2.Employee service 5 - 10 years  - 29 days  entitlement. when generating quota for employee less than five years its calculating correctly.when come's  to e

  • How to stored data after clicking checkbox in data base table Update:10-11

    REPORT  ZT                                      . TYPE-pools: slis. tables:mkpf,mseg,mard,COWB_COMP,ZTABLE. Types:BEGIN OF tp_data,      mblnr LIKE mseg-mblnr,      matnr LIKE mseg-matnr,      werks LIKE mard-werks,      lgort LIKE mard-lgort,      l

  • Differnace b/w SID and Global data base name Update:10-11

    please tell me what is differance b/w SID and global data base name.Hi, Oracle System Identifier (SID) A name that identifies a specific instance of a running pre-release 8.1 Oracle database. For any database, there is at least one instance referenci

  • REPORT AND DATA BASE SETUP Update:10-11

    i have been using CView Manager 11 to do my reports and is relatively easy to setup reports to the data base, but not all of my reports work with this program plus there is no user manual available.  So I am trying to switch over to Chrystal Reports

  • Creating a Crystal Report from a non-SAP data base Update:10-11

    I have the following scenario server1\myDataBase server1\SAP\sapDataBases in sapDataBases I have about 30 company databases. I am trying to create a report, that gets informatino from a table/view/SP from server1\myDataBase, when I try to PREVIEW or

  • Creating a Single Report from Oracle Data Base and BI Answers Update:10-11

    Hi, I wanted to create a single report by using a BI Report where in we have project and Activity columns,now I want to add column with Program to see the results.Program data is in Oracle Database. Can some one help me how to create the report. ii.H