473,836 Members | 2,111 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

good table design...

Hello,

I am designing a table of vehicle types, nothing special, just a list of
unique vehicle types such as truck, lorry, bike, motor bike, plane, tractor
etc etc

For the table design I am proposing a single column table with a field name
called vehicle_type and this will contain the vehicle type.

Sot it will be

vehicle_type
car
bike
tractor
plane
truck
van
blah
blah
blah

Is this ok? Or is there a better way to do it?

Thanks,

td.

Jul 20 '05
36 4660
David Portas (RE************ *************** *@acm.org) writes:
Identifying the keys is an essential part of the process of designing the
logical model anyway.


And I say it again: that identification process could result in that you
realize that there is no real-world key which meets the requirements of the
relational model.

--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #31
Logically impossible. Any relation {A,B,C} represents a fact. If the fact is
representative of some quantity that you need to represent N times then you
can always add another attribute to represent the count of N: {A,B,C,n}. You
can therefore always record any set of facts without violating any key. In a
table that doesn't represent quantitative facts there is obviously no
problem at all - each fact need only be recorded exactly once.

The idea that a particular schema design is a consequence of Business
Process is a common falacy I believe. A relational schema *models* a
business process it is not *determined* by it. There are always choices to
be made in the design and business constraints are not an excuse for poor
design.

--
David Portas
SQL Server MVP
--
Jul 20 '05 #32
David Portas (RE************ *************** *@acm.org) writes:
Logically impossible. Any relation {A,B,C} represents a fact. If the
fact is representative of some quantity that you need to represent N
times then you can always add another attribute to represent the count
of N: {A,B,C,n}. You can therefore always record any set of facts
without violating any key. In a table that doesn't represent
quantitative facts there is obviously no problem at all - each fact need
only be recorded exactly once.
Yes, you might be able to add another attribute, but in the end you have an
attribute list which is long as the universe, and which have no practical
usage, and only serves to make the system more difficult to use and less
effecient.
The idea that a particular schema design is a consequence of Business
Process is a common falacy I believe. A relational schema *models* a
business process it is not *determined* by it. There are always choices to
be made in the design and business constraints are not an excuse for poor
design.


Real-world systems are built to solve business problems, not to appease
the ideas of relational theory. Just as always using an surrogate key is
poor design, it is also poor design to always define a natural key.

--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #33
toedipper wrote:
Thanks for your reply.

Totally of topic but what does 'sic' mean? I see this all over the place
both on the web and in print.

Thanks,

TD.
"--CELKO--" <jc*******@eart hlink.net> wrote in message
news:18******** *************** ***@posting.goo gle.com...
For the table design I am proposing a single column table with a


field [sic] name called vehicle_type and this will contain the vehicle
type... Is this ok? <<

Sure, if you remember to make the one column the primary key. It is
weird just hanging out there in space without anything in the schema,
but it is legal. And fields are not anything like column.


According to the dictionairy it (sic) means:
1. To set upon; attack.
2. To urge or incite to hostile action; set: sicced the dogs on the
intruders.

In sms language it means "As I See". I think.
Regards Kees
Jul 23 '05 #34
sic1
adv.
Thus; so. Used to indicate that a quoted passage, especially one
containing an error or unconventional spelling, has been retained in its
original form or written intentionally.

Regards,
Jim

"cwepema" <cw*****@presys .nl> wrote in message
news:Zu******** **********@news fe01.lga...
toedipper wrote:
Thanks for your reply.

Totally of topic but what does 'sic' mean? I see this all over the place both on the web and in print.

Thanks,

TD.
"--CELKO--" <jc*******@eart hlink.net> wrote in message
news:18******** *************** ***@posting.goo gle.com...
>For the table design I am proposing a single column table with a

field [sic] name called vehicle_type and this will contain the vehicle
type... Is this ok? <<

Sure, if you remember to make the one column the primary key. It is
weird just hanging out there in space without anything in the schema,
but it is legal. And fields are not anything like column.


According to the dictionairy it (sic) means:
1. To set upon; attack.
2. To urge or incite to hostile action; set: sicced the dogs on the
intruders.

In sms language it means "As I See". I think.
Regards Kees

Jul 23 '05 #35
How do think that Fed Wire and the other banking networks handle their
transactions? It ain't GUIDs and IDENTITY columns; it is very
intelligent keys that can be verified.

Jul 23 '05 #36
tzutrfi8t797to0 zh9ð'0uzjhð+u'0
"toedipper" <se************ ******@hotmail. com> wrote in message
news:30******** *****@uni-berlin.de...
Hello,

I am designing a table of vehicle types, nothing special, just a list of
unique vehicle types such as truck, lorry, bike, motor bike, plane,
tractor
etc etc

For the table design I am proposing a single column table with a field
name
called vehicle_type and this will contain the vehicle type.

Sot it will be

vehicle_type
car
bike
tractor
plane
truck
van
blah
blah
blah

Is this ok? Or is there a better way to do it?

Thanks,

td.

Jul 23 '05 #37

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

24
3627
by: matty | last post by:
Go away for a few days and you miss it all... A few opinions... Programming is a craft more than an art (software engineering, not black magic) and as such, is about writing code that works, first and foremost. If it works well, even better. The same goes for ease of maintenance, memory footprint, speed, etc, etc. Most of the time, people are writing code for a use in the *real world*, and not just as an academic exercise. Look at...
52
6451
by: Tony Marston | last post by:
Several months ago I started a thread with the title "What is/is not considered to be good OO programming" which started a long and interesting discussion. I have condensed the arguments into a single article which can be viewed at http://www.tonymarston.net/php-mysql/good-bad-oop.html I fully expect this to be the start of another flame war, so sharpen your knives and get stuck in!
1
4210
by: David Thompson | last post by:
Looking for a book to help me develop a philosophy for building databases (particularly on MySQL). And then taking them from concept to construction. Something like.... Start by asking which queries you will be performing, then define all data needed for each of those queries, then progress to normalize this data, etc. Any Ideas....thanks...
3
2030
by: cassandra.flowers | last post by:
I'm designing a database because I have to do it for the preperation work for my A-Level ICT exam. The database is for a building company. It has to store information on building projects (tblProject) and employees (tblPersonnel) then link them together.
15
2740
by: Hi5 | last post by:
Hi, I am designing a database for a client in which It has a client table including the followings: 1-Table Client 2-Table lookupcategory 3-Table Ctegory
7
1849
by: farseer | last post by:
Here is the scenario: I have an interface which defines get methods for data that will make up a row in a table. However, the source of this data may, over time, switch/change (The company may choose to change data providers). Therefore i thought to myself, a type of Adapter Pattern is best here and so i proceeded with that. here's an example of what i did (note this implementation differs from the text book one due to the way data...
4
3939
by: Nathan Sokalski | last post by:
When editing an ASP Table, Visual Studio does not allow me to edit it in Design View. This makes it harder to add elements, because I must add every element either by using Design View to create the element outside of the table and then using cut & paste in HTML View to move it to the desired location, or by manually typing the code in using HTML View. The first technique sometimes does not automatically update the list of elements...
7
4869
by: david | last post by:
I have asked this question before. But it does not work for me. Given radion buttons in the web form design page. What I did is described as follows. A panel control is dragged into the design form, and a table control is dragged into the panel from tooolbox. Add cells for the table through the properties. Now I cut a radio button, and click the table (note I can not select a cell), then right click Paste. The button is not in expected...
3
1354
by: Chris | last post by:
Hi again, I need another good practise advice. Everybody (100 persons) in our compagny manages one or more projects. Each projects needs two tables: table 'project' (general information), table 'projectdetails' (details of projects) and one or more result tables (one per project) like 'projectresult1', 'projectresult2' etc ... One project needs more or less 300 records with 6 fields (with size: nvarchar(200) average)). Nothing...
0
9810
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9656
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,...
0
10527
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10575
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,...
0
10241
tracyyun
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...
0
9358
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7774
isladogs
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...
0
6975
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
4443
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 using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.