Database Design

What are the points to be taken care of when designing a database on Linux?

What are the points to be taken care of when designing a database on Linux? What are the different replication methods available?

database

How to make an offline database that can be access through network

DB question(s) that I have never heard a direct answer for

In designing a database for use where I work, I ran smack-dab into a few old questions I have always had relating to relational databases.  I say "old" questions because I developed them a long time prior.  However, I think the answers are entirely relevant today (obviously, otherwise I wouldn't...

Advantages and disadvantages of MySQL 5.0

Can someone explain me what are the advantages and disadvantages of MySQL 5.0??

With an Access form based on 1 table, can I have info from a related table automacially appear based on linked field?

With a form based on 1 table, can I have info from a related table automacially appear based on linked field? For example, let's say I have two tables linked by a Vendor ID number. On a form that is based on the Purchase Order table, I'd like the Vendor name to automatically appear on the form...

Unique ID for existing table

I want to add a column to an existing table where its values should be unique and auto generated in a sequential order

How to implement a "is a"/generalization relationship in an ERD?

I'm using SQL Server 2005 Developer edition.

SQL query and Oracle database design help needed

Sorry for all the confusion with the questions.So let me clear myself,i am doing this not as assignment or homework,but something which interests me and trying to leran.Earlier as I stated that its a part of my school(** well frnakly speaking, it was my plan if i could put this as an item of the...

Performance of very large SQL Server table with millions of rows

Performance of very large sql server table with millions of rows: - I have a SQL server database - I have more than 200 tables in the database - I have one table that contains information on every row in all the tables. So this table will have millions of rows (Let us name it Bigtable) - Any data...

1:1 Modeling Inheritance 1:1

I am working on a database to store employment history. A person can be employed by an organization or another person. I created the following tables: Person Organization Employer Employment Person and Organization both have a 1:1 relationship with Employer. Employer has a 1:M relationship with...

How to test whether the Database tables designed to avoid deadlock occurence?

I heard from our dev team that our db tables are designed such that there is no chance of deadlock. How to test whether the Database tables design avoids deadlock? By reviewing the db scripts (table creation) can we find whether the db table design is deadlock proof or not? What else can we...

Database design

Hi all, I have a condition and formula generator in my application. I must save this condition and formula in database and calculate formulas for each condition. I want to model these conditions and formulas. For example: Condition: Education=BS AND MaritalStatus=Married AND YearsOfService>10...

Database design schema for Test Data Management?

For test data analysis across the builds, platforms etc, we are thinking of storing the test execution results into the database. Please let me know if any one has already designed the db schema for test case & report management.

designing indexes

I have a question regarding database design. Lets assume that there is a table with 10 columns. I don't have any single column which I can choose as candidate for Primary key. Though, combination of 5 columns can uniquely identify records. Here, I created an identity column as a PK and added...

Access 2007 Complex Calculations

In Access 2007 I need to enter raw test data into tables, perform complex calculations including linear trends, then store the calculated results. These are the only numbers I really care about. The raw test data could be deleted for all I care, I just need the calculated results. I will need to...

Hardware requirements for SQL Server 2005

Hi all, We are looking into creating a SQL 2005 server (Windows 2003 R2 SP2 Enterprise Ed.) with 3 databases. Size of the db 's will be app. 50 GB, 15 GB and 7 GB. Amount of continuous logged on users is app 20. Can anyone recommend the amount of CPU + clockspeed of the CPU's, RAM memory and...

Efficient storage of survey answers

We have a website that asks the user a set of questions. The answers are curently stored in SQL database using a table that has: PersonID QuestionID AnswerID Value So one answer to one question is stored in each record. Some questions have more than one possible answers, so all answers to a...

How to calculate my DataBase size

Dear all, I like to calculate my database size , can u tell me the views and formula to calculate my DB size please

Designing Table Layout

Hi, I am doing very simply frequencies and descriptives but wondered if I can design the layout of the output table myself rather than exporting to Excel and copy pasting a million times...can anyone help?

Database Question.

Hello all .. I am doing an Internship with a company in Nashville that does community branding. Recently I received a project to design a database which would house all of the information that we would need to show to potential clients to gain their business. Such as particular information...