Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-06 : 09:16:26
|
| Prakash writes "Dear Friends,I am developing a package for a fishing company. It has 10 Vessels which go around for fishing. Each of these vessels go for around 45 Days Voyage in the sea. Each contain a Captain, Engineer and crew members. Each vessel catches the same kind of Fish or Prawns, Hence items caught in all the vessels are the same , Of course the quantities varies according to the location , where they are fishing , season etc. The management wants to keep track of the catch on a daily basis , voyage basis , captain wise, season wise, location wise etc. Each of these items are associated with a rate in local currency for fish and US Dollar for Prawns. This is because Fish is Locally sold and Prawns are being exported. At present the management is monitoring the daily catch value each vessel is catching. The catch details are taken everyday morning from the sea-coast. Sometimes the captain or engineer are changed due to some technical or personal needs. These things are also to be tracked along with the date .My concern is how should I design the tables.I have something of this sort in my mind.How should take the input of the catch on a daily basis.1> Shall I create a single table with the following FieldsItem_Rowid, Vessel_One, Vessel_Two……Vessel_TenAnd program in such a way to capture into this table.2> Or Shall I create a separate table for each vessel in such a way.Item_Rowid,Item_CatchI am Totally confused please guide meRegdsPrakash" |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-05-06 : 09:21:07
|
| Ha ha ha ha ha ha ha haUmm, yeah I am really sure that you are developing an identical application to one in a Microsoft exam.You just broke the terms of your NDA by posting that question. You are not going to get any help for that one here.Damian |
 |
|
|
|
|
|
|
|
Database Design