Description:
Discussing advances in database technology.
|
|
|
SQLfly New Generation Database Tool
|
| |
SQLfly is a database management, schema/system compare, database quality reports and database query tool to make every day work more productive. Currently supports ORACLE Databases (Oracle 9i, 10g, 11g). SQLFLY provides both Desktop and Mobile version of the products to access database anywhere, anytime!... more »
|
|
|
"Structured" Entity-Relationship Model?
|
| |
Hello,
coming from the "practitioner" side, I wonder what relational theorists
think about "structured entity relationship" modelling:
[link]
For me the essential aspect seems to be the rule (which doesn't even
seem to be mentioned in the english-language Wikipedia article) that the... more »
|
|
|
The same simple question to relational theorist (with video now).
|
| |
Hi everyone. Last year I asked a question:
"…is a way of how I create the normal relations important? Suppose a part of system exists which creates the relations according to some external non-normar expression descrided some data. This part of system translates external expression into commands which create a set of normal relations. So user of such system gives to the system some non-normal data description expressions but operates with the data presented in form of normal virtual relations only. (once again - all data are presented for user in form of normal relations). Is such system relational?"... more »
|
|
|
Jim Hodges, 6StringStu, Six String Stu, James Stuart Hodges 677
|
| |
677
577 SW Dexter Cir, Apt 201
1442 SW Haygood Loop, Apt 101
Lake City, FL 32025
(386) 438-8968
Local PD: (386) 752-4344
...Newsgroups: alt.social-security-disability
..." Of the three felonies on my record,
1: Violation of the Mann act (federal kidnapping...)....
2nd Felony arrest Homicide........... more »
|
|
|
How to normalize this?
|
| |
Hi all,
I've been thinking about a scenario for a few days now, and I still am not sure how this should be normalized. Maybe someone here can help?
The first part is easy. I have five attributes (a, b, c, d, e) and the following FDs:
1. {a, b, c} --> d
2. {a, b, c} --> e
Obviously, just a single relation with all five attributes and (a, b, c) as candidate key.... more »
|
|
|
Jim Hodges, 6StringStu, Six String Stu, James Stuart Hodges 2258
|
| |
2258
James S Hodges
577 SW Dexter Cir, Apt 201
1442 SW Haygood Loop, Apt 101
Lake City, FL 32025
(386) 438-8968
Local PD: (386) 752-4344
...Newsgroups: alt.social-security-disability
..." Of the three felonies on my record,
1: Violation of the Mann act (federal kidnapping...)....
2nd Felony arrest Homicide........... more »
|
|
|
