Hi all,
I am trying to design a database in access 2002. I have multiple category of
items such as computers which may include laptop, server, pc...all of these
items have different attributes, similarly printers with sub categories
deskjet, laser, line, etc also have diff attributes...li ke that I have
multiple items in my inventory (around 30 items) all with different
attributes. After going through normalisation I guess I need to have
separate tables for each laptop, Server, Computer etc OR have a one to one
relation with item category such as computers 1 to 1 laptop , servers. By
doing that I will have a lot of tables which I guess is not the best way to
do this.
I have to assign them to customers which is related through a many to many
relation...junc tion table .tbltransaction s.... with tblcategory at present
and will be choosing multiple items which might include printers, computers,
routers, switches, etc.
Please suggest if there is a best practise for doing this OR anyway I can
simplify the table design. Thanks to all in advance.
Awaiting eagerly for your response.
--
Regards,
B 4 4847
"Burghew" <no****@sorry.c om> wrote I am trying to design a database in access 2002. I have multiple category of items such as computers which may include laptop, server, pc...all of these items have different attributes, similarly printers with sub categories deskjet, laser, line, etc also have diff attributes...li ke that I have multiple items in my inventory (around 30 items) all with different attributes. After going through normalisation I guess I need to have separate tables for each laptop, Server, Computer etc OR have a one to one relation with item category such as computers 1 to 1 laptop , servers. By doing that I will have a lot of tables which I guess is not the best way to do this. I have to assign them to customers which is related through a many to many relation...junc tion table .tbltransaction s.... with tblcategory at present and will be choosing multiple items which might include printers, computers, routers, switches, etc. Please suggest if there is a best practise for doing this OR anyway I can simplify the table design. Thanks to all in advance.
equipment
=======
equipment_id
eq_cat_id (fk)
eq_type_id (fk)
eq_serial_no
eq_model
lu_eq_category
=========
eq_category_id
eq_cat_desc {printer, computer, monitor, speakers}
lu_eq_type
=======
eq_type_id
eq_cat_id (fk)
eq_type_desc { ink, laser, laptop, server, LCD, CRT }
On a form, first choose an eq_cat_id from a listbox or combox that uses
lu_category_id as the lookup table.
Then requery the second listbox/combobox, which has as its rowsource a
query like "SELECT eq_type_id, eq_type_des FROM lu_eq_type WHERE eq_cat_id="
& Me.cboCategory"
--
Darryl Kerkeslager
Power corrupts.
Absolute power corrupts absolutely.
Knowledge is power.
See www.adcritic.com/interactive/view.php?id=5927
Just a suggestion because things have changed since I designed a similar Db
where we sold a client a system, and networks were uncommon.
If I were doing it now, I think I would have
A TblEquipment:-EqipmentID, TypeID(FK), Serial,
TblTypes:-TypeID, Type e.g. Computer, Printer, Router
TblCategories:-CategoryID, Category, TypeID e.g. LaserJet, Laptop
TblJoinEqipment Category:-EqipmentID, CategoryID but a check that the
TypeID is consistent, i.e you can have a LaserJet printer, but you can't
have a LaserJet computer.
This should allow you to build a piece of equipment and show it's
categories.
Then as you surmised you have a TblCustomer, CustomerID, Customername etc
and a JoinCustomerEqu ipment with date, Price etc
Idle thoughts
Phil
"Burghew" <no****@sorry.c om> wrote in message
news:d0******** *@news-dxb.emirates.ne t.ae... Hi all,
I am trying to design a database in access 2002. I have multiple category of items such as computers which may include laptop, server, pc...all of these items have different attributes, similarly printers with sub categories deskjet, laser, line, etc also have diff attributes...li ke that I have multiple items in my inventory (around 30 items) all with different attributes. After going through normalisation I guess I need to have separate tables for each laptop, Server, Computer etc OR have a one to one relation with item category such as computers 1 to 1 laptop , servers. By doing that I will have a lot of tables which I guess is not the best way to do this. I have to assign them to customers which is related through a many to many relation...junc tion table .tbltransaction s.... with tblcategory at present and will be choosing multiple items which might include printers, computers, routers, switches, etc. Please suggest if there is a best practise for doing this OR anyway I can simplify the table design. Thanks to all in advance. Awaiting eagerly for your response. -- Regards, B
Read Rebecca Riordan's article at Access web on subclassing in Access.
One of the reasons VB.NET *should* be better - it can do real
subclassing and all the inheritance and all that. You might want to
look at Peter Vogel's book too (Object and component handbook). http://www.mvps.org/access/tables/tbl0013.htm
<pi********@hot mail.com> wrote in message
news:11******** **************@ g14g2000cwa.goo glegroups.com.. . Read Rebecca Riordan's article at Access web on subclassing in Access. One of the reasons VB.NET *should* be better - it can do real subclassing and all the inheritance and all that. You might want to look at Peter Vogel's book too (Object and component handbook).
Yes, but none of the object stuff works with sql server...so what good does
that do? If you use ms-access, or you use c#.net, they both still have to
use sql statements to grab the data from JET, or sql-server. The issues of
using .net will NOT effect a correctly formed and normalized database (and,
I not suggesting that you are saying otherwise, but the issues of a OO
programming languages has little, or nothing to do with the fact that using
JET (ms-access), Oracle, or ms-sql requires a good normalized design here,
and the approach here does not differ).
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada pl************* ****@msn.com http://www.members.shaw.ca/AlbertKallal This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Roderik |
last post by:
Hi,
When developing a website in general when should I choose to put
content in a database. For menu options, settings, and listings like
products it seems to be clear for me to put them in. But the main
content (article for example) should I put that in a page or in the
database. More in general, when would it benefit to use a database and
when not. Does anyone know a good tutorial or do you have advice
concerning this.
|
by: Cherrish Vaidiyan |
last post by:
hello,
Thanx for the suggestions on my Listener query. Now i am performing a
simple work.. STANDBY DATABASE creation.
I have followed the instraction from Oracle 9i Release 1 documentation
but have some doubts. here are the basic stpes i followed.
1 Either make a new backup of the primary database datafiles or access
|
by: Cherrish Vaidiyan |
last post by:
sir,
The following are the steps that i followed in setting up standby
database on Red hat Linux 9. i am using Oracle 9i.
i have followed the steps in this site :
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96653/create_ps.htm#66206
Still i give the steps i followed.
Preparing the Primary Database for Standby Database Creation
|
by: Marvin Libson |
last post by:
Hi All:
I am running DB2 UDB V7.2 with FP11. Platform is Windows 2000. I
have created a java UDF and trigger. When I update my database I get
the following error:
SQL1224N A database agent could not be started to service a request,
or was
terminated as a result of a database system shutdown or a force
command.
|
by: Kamlesh |
last post by:
Hi,
How do I know the physical database path of a database. When I goto
the DB2INSTANCE users's directory (/home/db2inst1), I see following
folders:
/db2inst1/NODE0000/SQL00001
/db2inst1/NODE0000/SQL00002
/db2inst1/NODE0000/SQL00003
/db2inst1/NODE0000/SQL00004
| |
by: pintur |
last post by:
The message is:
SQL1036C Errore di I/O durante l' accesso al
database. SQLSTATE=58030
what is the proble?
what for restore tables?
thanks
|
by: PC Datasheet |
last post by:
Looking for suggestions ----
A database was designed for a national automobile inspection program. In
it's simplest form, the database has two tables:
TblOwner
OwnerID
<Year/Make/Model owned by owner, Owner name/address, etc)
TblInspection
InspectionID
|
by: HSP |
last post by:
hi.
i need to restore an old database. The db was backed up using a DLT drive,
using 2 volumes. The content for the tapes was copied to file onto Solaris
machine using rsh and dd (for backup purposes). Now, the drive is defective
and can't read the tapes anymore.
Server is AIX 4.3.2 and database is IBM DB2 Server (DB2 for AIX Version
2.1.2)
|
by: mel_apiso |
last post by:
Hi,
after uncatalog one database, and catalog again with other name, if I
try to connect
with this database, everything is ok, but list applications only show
me the
connection with the uncatalog/catalog database. After I disconnect from
this database,
list applications command show all instances connection.
Below I paste the situation.
|
by: Scott Jones |
last post by:
Hello,
In an attempt to save disk space, I went in and gzipped all of the log
files for my database running DB2 version 7.2 . This resulted in the
database being marked bad because a log file was no longer found (I
think).
Here is an excerpt from db2diag.log:
String Title:sqleMarkDBad: PID:7980 Node:000
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |