Newbie table Layout (Posted as suggested by Tom Lake for feedback)

Newbie table Layout (Posted as suggested by Tom Lake for feedback)

Post by Little Pen » Mon, 26 Dec 2005 15:04:32


o just add some info to my earlier post. This is my layout for a database to keep track of computer hardware and software. Just to give a little
info. There are of 1500 workstations, numerous, printers, peripheral and so on. I want to track them from the time they come in the door until the
time there discarded. Part of the naming convention in the domain has to do with the building 98% of the time. Oh, by the way there are about 12
different buildings and many different rooms. One thought of I have in mind was to create a relationship from the location table to computer, printer,
and monitors tables. Not sure if that is the best way. In quite a few cases, there are more the one users of a computer.

Also looking ahead if a person installs a new computer in room 201. Since the computer info is entered once a computer arrives at the warehouse how do
I connect the dots with a form. I'm trying to visualize how this happens and what info I need and how do I get it. In my mind I, lookup the computer
info by serial number and attach a location and a monitor to it. However, do I have to sort through 4 or 5 hundred locations id number to link them
because the are linked by primary key ID which is a number. Maybe someone can elaborate for me.

I know I am in over my head but I am learning.


Ok here my table layout that Tom Lake suggested I post for feedback.


Tables Documentation

Table: tbl_Computers

(PK) Primary Key
Field Name Description Type Length
ComputerID (PK) Auto Number 4
Computer_Manufacturer ComputerManufacturer Text 50
Computer_Model Computer model number Text 50
Computer_ProductID Manufacturer Product ID Text 50
Computer_SerialNumber Computer Serial number Text 50
Computer_OperatingSystem Operating System Text 50
Computer_RAM Amount of system RAM Long Integer 4
Computer_CPU_Type Type of Computers processor Text 50
Computer_CPU_Speed Speed of Computers processor Text 50
Computer_HDD_Manufacturer Harddrive Manufacturer Text 50
Computer_HDD_Size Harddrive Space Long Integer 4
Computer_HDD_SerialNumber Harddrive Serial Number Text 50
Computer_HDD_IDE Does computer support IDE? Yes/No 1
Computer_HDD_SCSI Does computer support SCSI? Yes/No 1
Computer_HDD_Serial_ATA computer support Serial ATA? Yes/No 1
Computer_DVDRW computer have a DVD +/- RW? Yes/No 1
Computer_DVD Does Computer have DVD? Yes/No 1
Computer_CDRW Does Computer have CD-RW Yes/No 1
Computer_CDRom Does computer have CD-Rom Yes/No 1
Computer_Floppy computer have floppy Drive? Yes/No 1
Computer_Wired_MAC Network Card Address Text 50
Computer_Wireless_MAC Computers Wireless Mac Address Text 50
Computer_Purchase_Date Date of Purchase Date/Time 8
Computer_Domain_Name DNS Name of computer Text 50
Computer_Firewire Does computer support Firewire Yes/No 1
Computer_USB Does computer support USB Yes/No 1
Computer_Notes Notes about this computer Memo
Computer_Barcode Barcode inventory Text 50
Computer_WarrantyEnd_Date Date Warranty Expires Date/Time 8
UserID Long Integer 4
LocationID Long Integer 4
MonitorID Long Integer 4




Table: tbl_Laptop
Description:

Field Name Description Type Length
LaptopID(PK) Auto Number 4
Laptop_Manufacturer Laptop Manufacturer Text 50
Laptop_Model Computer model number Text 50
Laptop_ProductID
 
 
 

Newbie table Layout (Posted as suggested by Tom Lake for feedback)

Post by tina » Mon, 26 Dec 2005 15:52:11

enny, once you post a question and get one or more responses, it's much
better if you post additional information, comments, etc, in *the same
thread*. the folks who responded (and you got two experienced developers
posting back, which is excellent) may very well "flag" the original thread,
and not see posts in another thread.

also, other folks may see and respond to the second thread - now you have
two threads running independently, and people working in one can't see and
comment on the posts in the other. that leads to duplication of effort and
frustration for everyone.

suggest you copy your post, that started this thread, back to the original
thread. don't be concerned that you haven't got a response in several hours
in the original thread. you have to take into account that 1) this is a
weekend, and 2) it's a holiday weekend, and 3) folks from all over the world
post in these groups, so there's a time difference issue to consider, and 4)
even on ordinary days, and weekdays, it's not unusual for a threaded
discussion to continue over several days, with large gaps between posts.
you're getting free help from folks who volunteer their time and have "day
jobs" that demand their attention, just like you, so you'll need to be
patient.

hth


"Little Penny" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...
to keep track of computer hardware and software. Just to give a little
so on. I want to track them from the time they come in the door until the
do with the building 98% of the time. Oh, by the way there are about 12
mind was to create a relationship from the location table to computer,
printer,
cases, there are more the one users of a computer.
the computer info is entered once a computer arrives at the warehouse how do
and what info I need and how do I get it. In my mind I, lookup the computer
do I have to sort through 4 or 5 hundred locations id number to link them
can elaborate for me.



 
 
 

Newbie table Layout (Posted as suggested by Tom Lake for feedback)

Post by Little Pen » Tue, 27 Dec 2005 01:44:13

First, I want to apologize for starting a new thread in this subject. Someone else kindly brought it to my attention. Obviously, it shows my lack of
experience in communication in this type of forum. I would like to direct any greatly appreciated comments to the tread subject of "Newbie Looking for
Help" Dated 12-24-05

My sincerest apologies

George