Re: Newbie table Layout (Posted as suggested by Tom Lake for feedback)
- From: "tina" <nospam@xxxxxxxxxxx>
- Date: Sun, 25 Dec 2005 06:52:11 GMT
Penny, 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" <Lilpenny747@xxxxxxxxxxx> wrote in message
news:dibsq1derdln0fdns2pp5a6l5p93shb8qj@xxxxxxxxxx
> To 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 Manufacturer Product ID Text 50
> Laptop_SerialNumber Laptop Serial number Text 50
> Laptop_OperatingSystem Laptop Operating System Text 50
> Laptop_RAM Amount of system RAM Long Integer 4
> Laptop_CPU_Type Type of processor Text 50
> Laptop_CPU_Speed Speed of Laptop processor Text 50
> Laptop_HDD_Manufacturer Harddrive Manufacturer Text 50
> Laptop_HDD_Size Harddrive Size Long Integer 4
> Laptop_HDD_SerialNumber Harddrive Serial Number Text 50
> Laptop_HDD_IDE Laptopr support Serial IDE? Yes/No 1
> Laptop_HDD_SCSI Laptop support Serial SCSI? Yes/No 1
> Laptop_HDD_Serial_ATA Laptop support Serial ATA? Yes/No 1
> Laptop_DVD Laptophave DVD Rom? Yes/No 1
> Laptop_DVDRW Laptop have a DVD +/- RW? Yes/No 1
> Laptop_CDRom Does the Laptop have a CDRom Yes/No 1
> Laptop_CDRW Does Laptop have CD-RW Yes/No 1
> Laptop_Floppy Does Laptop have floppy Drive? Yes/No 1
> Laptop_Wired_MAC Laptops Network Card Address Text 50
> Laptop_Wireless_MAC Laptop Wireless Mac Address Text 50
> Laptop_Purchase_Date Laptop Date of Purchase Date/Time 8
> Laptop_NetworkName DNS Name of computer Text 50
> Laptop_Firewire Does Laptop support Firewire Yes/No 1
> Laptop_USB Does Laptop support USB Yes/No 1
> Laptop_Notes Notes about this computer Memo
> Laptop_Barcode Barcode number Text 50
> Laptop_WarrantyEnd_Date Date Warranty Ends Date/Time 8
> Laptop_Signature Has User Singed For Laotop Yes/No 1
> Laptop_Date_U_Received Date User received Laptop Date/Time 8
> Laptop_Date_U_Returned Date User returned Laptop Date/Time 8
> UserID Long Integer 4
>
>
> Table: tbl_Location
> Description:
>
>
> Field Name Description Type Length
> LocationID (PK) Auto Number 4
> Location_Building Building Text 50
> Location_RoomNumber Room Number Text 50
> Location_Department Department Text 50
> UserID Long Integer 4
> ComputerID Long Integer 4
> MonitorID Long Integer 4
> PrinterID Long Integer 4
> PeripheralID Long Integer 4
>
>
> Table: tbl_Monitor
> Description:
>
>
> Field Name Description Type Length
> (PK) Monitor_ID Auto Number 4
> Monitor_Manufacturer Monitor Manufacturer Text 50
> Monitor_Model Monitor Model Number Text 50
> Monitor_ProductID Manufacturer ProductID Text 50
> Monitor_Size Monitor Size Text 50
> Monitor_SerialNumber Monitor Serial Number Text 50
> Monitor_Purchase_Date Date/Time 8
> Monitor_WarrantyExpires Date/Time 8
> Flat_Screen Yes/No 1
> CRT Yes/No 1
> Monitor_Notes Memo
> ComputerID Long Integer 4
> LocationID Long Integer 4
>
> Table: tbl_Peripheral
> Description:
>
>
> Field Name Description Type Length
> PeripheralID (PK) Auto Number 4
> Peripheral_Type Type of Peripheral Text 50
> Peripheral_Manufacturer Brand of Peripherals Text 50
> Peripheral_Model Model of Peripheral Text 50
> Peripheral_ProductID Text 50
> Peripheral_SerialNumber Serial Number of Peripheral Text 50
> Peripheral_Purchase_Date Date of Purchase Date/Time 8
> Peripheral_Notes Notes on this item Memo
> Peripheral_MAC_Address Mac Address - Where applicable. Text 50
> Peripheral_DNS DNS Name, Where applicable. Text 50
> Peripheral_IP IP Address, Where Applicable. Text 50
> Peripheral_Barcode Barcode Number Long Integer 4
> Peripheral_Signature for (Camera, Camcorder etc) Yes/No 1
> Peripheral_Date_U_Received Date User Received Date/Time 8
> Peripheral_Date_U_Returned Date User Returned Date/Time 8
> Peripheral_WarrantyExpires Date/Time 8
> UserID Long Integer 4
> ComputerID Long Integer 4
> LocationID Long Integer 4
>
> Table: tbl_Printers
> Description:
>
>
> Field Name Description Type Length
> PrinterID (PK) Auto Number 4
> Printer_Manufacturer Printer Manufacturer Text 50
> Printer_Model Printer model number Text 50
> Printer_ProductID Text 50
> Printer_SerialNumber Printer Serial number Text 50
> Printer_DNS_Name Network Name Text 50
> Printer_Network_Printer Yes/No 1
> Printer_Slave Yes/No 1
> Printer_IPaddress Text 50
> Printer_Wired_MAC Text 50
> Printer_Purchase_Date Printer Date of Purchase Date/Time 8
> Printer_WarrantExpires Date/Time 8
> LocationID Long Integer 4
>
>
> Table: tbl_Software
> Description:
>
>
> Field Name Description Type Length
> SoftwareID (PK) Auto Number 4
> Software_Company Text 50
> Software_Name Text 50
> Software_Version Text 50
> Software_ProductID Text 50
> ComputerID Long Integer 4
>
> Table: tbl_UserInfo
> Description:
>
>
> Field Name Description Type Length
> UserID (PK) Auto Number 4
> User_FName Text 50
> User_LName Text 50
> User_PhoneExt Text 50
> User_CellPhone Text 50
> User_Pager Text 50
> User_Email Text 50
> LocationID Long Integer 4
> ComputerID Long Integer 4
> LaptopID Long Integer 4
> PeripheralID Long Integer 4
.
- References:
- Newbie table Layout (Posted as suggested by Tom Lake for feedback)
- From: Little Penny
- Newbie table Layout (Posted as suggested by Tom Lake for feedback)
- Prev by Date: Newbie table Layout (Posted as suggested by Tom Lake for feedback)
- Next by Date: Re: Still need help - on form
- Previous by thread: Newbie table Layout (Posted as suggested by Tom Lake for feedback)
- Next by thread: Re: Newbie table Layout (Posted as suggested by Tom Lake for feedback)
- Index(es):
Relevant Pages
|
