• 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?

    ITKE346,470 pointsBadges:
  • database

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

    Fritzeeker5 pointsBadges:
  • 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...

    VirgilReality20 pointsBadges:
  • 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 when...

    Swd14420 pointsBadges:
  • How to implement a “is a”/generalization relationship in an ERD?

    I'm using SQL Server 2005 Developer edition.

    Obhasha0795 pointsBadges:
  • 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

    Ragas60 pointsBadges:
  • 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...

    Rohit331225 pointsBadges:
  • 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...

    Elhajjh5 pointsBadges:
  • 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...

    Wolfrvr5 pointsBadges:
  • 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 do?...

    Saimadhu455 pointsBadges:
  • 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...

    Elham10 pointsBadges:
  • 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.

    Saimadhu455 pointsBadges:
  • 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 UNIQUE...

    Sqloholic25 pointsBadges:
  • 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...

    Ryanwd10 pointsBadges:
  • Database Project Definiton

    A corporation has decided to move its production data off the OS 390 platform to a windows platform running the windows data center operating system. *There are 18 terabytes of data of mission critical data that needs to be available 24 hrs a day. *Because of the size of the customer database they...

    Shifex0 pointsBadges:
  • 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 given...

    Eyoder5 pointsBadges:
  • 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 about...

    Vandy875 pointsBadges:
  • 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?

    CMS5 pointsBadges:
  • Split Databases – BE Structural Changes Version: 2007 (12.0)

    Can I make structural changes to the BE database without affecting the users? i.e. the relationships, proprieties Also, why do you have to put the FE on the users computer, can't you put their copy of the FE on the network, under a folder just for that user?

    Thuzinec10 pointsBadges:
  • Generic database design to store logs of every database change

    Hi there, Can anyone help me out by providing a generic database design for having logs of all the changes to my master table so that I can review all the changes at a later point of time through my application. Every response will be appreciated.... thanks, Sudhakar

    NAGA5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following