3NF Question. One For The Smart Ppl Here.

Feb 23, 2005

http://www.bcwwrestling.btinternet.co.uk/pirce_band_func_deps.jpg

I have table with the functional dependencies shown above.

I would like to know if it is in 3rd Normal Form. I think it is.

The table stores data on DVDs and Tapes.

Format = "Tape" or "DVD".

Region is either "1","2","3" or "0" (If format is DVD)
or "PAL" or "NTSC" (If format is Tape).

Rarity is a rating (1 to 5) of how rare a tape or dvd is. The user uses their descretion when deciding this value, but the take format and region into account when deciding.

Price is the cost of the tape or dvd. The rarity, region, and format are considered when the user decides upon a price.

Region, rarity and format are unique, and can only appear once in the table.

Finally, Price band is the primary key of the table. It is a value used solely to identify the combination of Format, region and rarity.

Im not sure if I have done the diagram correctly. Im not sure if I need to model a dependency if it is only there because the user is using data when deciding on the value of other data.

In which case, would this be the correct diagram, and is it in 3NF?

http://www.bcwwrestling.btinternet.co.uk/pirce_band_func_deps2.jpg

View Replies


ADVERTISEMENT

Dear Smart People,

Oct 11, 2005

I have a form with a textbox and a button. When the user enters in a number range, I need records to show up for only dates that are in-between and/or equal to the numbers typed in the textbox.

For example when the user types in 4-9, and pushes the button, a display of records will be displayed for only 4, 5, 6, 7, 8, 9 (if there are such records). The numbers are contained in a NUMBER field of a larger table.

This seems to be a tough question, and I've done days of research on it and can't find an answer.

View 1 Replies View Related

Smart Access Application (vbs)

Oct 30, 2006

Hello everyone. This is my first post (for not asking help :) )
I look at topics for start up options etc and I think all of this it’s ok but there is a smarmiest way to start your application. So here we go..
We make a vbs Script

Set WSHShell = CreateObject("WScript.Shell")
WSHShell.Run """C:Program FilesMicrosoft OfficeOFFICE11MSACCESS.EXE""/RUNTIME ""C:Documents and SettingsEvalDesktopDataBaseUI.mdb"""

And we start The Access In runtime and open your Db
Note this working with Access 2003 .If you have an other version just change the access directory “C:Program FilesMicrosoft OfficeOFFICE11MSACCESS.EXE”
Where is your Office Access
Then you can make a shortcut of your .vbs script and rename it ass you like
You’re Application Name. You can change the Icon (If you have a Program File’s Folder Place your icon) Right Click Properties/Change Icon
Then your app is starting in Access /Runtime and everything is fine :)

View 1 Replies View Related

Smart Key Prompt In Combo Box

Jul 14, 2006

Does anyone know how complicated would it be too allow the user to key in the first couple letters of the last name in the combo box & have the combo box prompt names that begin with those letters?

I thought I did this before, but I can't figure out how.

I would appreciate any advice.

View 2 Replies View Related

Forms :: Using Smart Tags With VBA?

Jan 9, 2014

Access 2007-2010 format Form, 9 bound fields, grouped together Smart Tag = "UnitGroup"

Summary: Needing to run VBA whenever the value is changed within one (or more) of these fields. User could be placing new value (defaults at 0) or editing(changing) previous value entered.

I am not good on writing loops/next statements. But I am wanting to make an image visible to true when someone changes the value within the group.

This is what I have so far:

Dim ctlGroup as Control
For Each ctlGroup in Me.Controls
If ctlGroup.Tag = "UnitGroup" Then 'finds the smart tagged controls
If ctlGroup Then 'if any fields within group changes value then
Me.Image321.Visible = True 'show image
End if
End If
Next ctlGroup

I don't even know if I am close with my code - clearly it is not complete and lots of holes of wonderment!! Maybe it would be easier just to use the individual even (on change) with each individual field (9).

View 2 Replies View Related

Remove All Smart Tags

Jan 17, 2012

I have an Access template I downloaded which has smart tags. I want to remove all smart tags all of the forms but how.

It must remove all tags as other users will be using the same database on different pc's. So mustn't be a local client setting.

View 3 Replies View Related

General :: Smart Date Picker

Jan 5, 2013

I am operating in MS Access 2007 and unfortunately have to stick with the "out of the box" controls. I have data entries of notes in my database for "most workdays" - but not holidays or weekends. I want to allow the user to be able to edit notes for "most workdays" - but not let them pick a day to edit that doesn't have notes - by selecting them from a calendar date picker. Essentially, I want to gray-out/lock the non-workdays from editing.Is there a smart enough Active X or other control as a Date Picker that uses the results of a query to show valid/invalid dates?

View 2 Replies View Related

Looking For Access Based Smart Business Software

Mar 10, 2007

We are looking for an access based software similar to this http://www.pedyn.com/access/P2000details.htm
Could any of you can guide us to get a best suit

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved