SSN as a Primary Key

If you were working on an EXISTING database that uses SSN as a Primary Key, what are some of the challenges you might face to add a new Primary Key?

Does anyone have any ideas of where flat-files are still used and why?

As far as flat-files go I think they really do have a place in some applications still. There are a couple of industries that rely on them heavily I am sure. Does any OTA's have any idea of where flat-files are still used and why?

Thinking in terms of elimination of redundant data

Thinking in terms of elimination of redundant data thus hopefully eliminating data corruption from operator input, would it not make sense to normalize and let the new Duo-Core, Quad-Core processors take-up the slack and even decrease query times?

Can a particular database be normalized hypothetically speaking after it has been put into production?

Can a database be normalized after it has been put into production or is it only normalized prior to rollout to the public or end user? If not, what are the alternatives to this?

DataBase design Using VB.NET and Ms Access

RENT-A-MOVIE DATABASE PROJECT I want to design a relational database to store information about my store (video rental store) customers and videotapes. I think the database will improve my ability to market to and provide enhanced service to my customers. Among the things I would like to be able to do, once the database i ...continues

Relational Databases

Consider the following relation schemas of a music store database. See attached file for full problem description.

Relational Databases

Consider the following relation schemas of a music store database. See attached file for full problem description.

Relational Database Limitations

Object-Oriented (OO) development is by far the most popular in the development arena today, however, object-oriented databases are not. Relational databases still rule the roost, however, this causes some headache for OO developers. A concept that many of the major database vendors have come up with is a hybrid database tha ...continues

DTD compared to XML Schema

Discuss the simplicity of the DTD compared to that of XML Schema. Has the trade-off gone too far towards complexity in trying to overcome the limitations of the DTD?

Schema for XML documents

There are a number of other Schema languages defined for use with XML documents apart from DTD and the W3C XML Schema. One of these is DSD. Investigate DSD as well as some other different Schema languages for use with XML, give a synopsis of each of the ones you find and compare some of the differences between these, DTD and XML ...continues