0
Database Design
Database design is the process of creating a detailed data model of a database. It is the next step after requirement gathering and before coding begins. A good database design can save a lot of time during the database development.
1,295 Questions
Repetition of Information is a condition in a relational database where the values of one attribute are determined by the values of another attribute in the same relation, and both values are repeated throughout the relation. This is a bad relational database design because it increases the storage required for the relation and it makes updating the relation more difficult.
- Inability to represent information is a condition where a relationship exists among only a proper subset of the attributes in a relation. This is bad relational database design because all the unrelated attributes must be filled with null values otherwise a tuple without the unrelated information cannot be inserted into the relation.
Regards,
Jose Deleep. S
Determining Attributes to Maximize Visibility of Objects?
I Want To Experiment With My Tresses Be It Hair Color Or A New Cut? Any Good Hair Salon in Solana Beach, CA!
What do you use when the table direction is horizontal or across the worksheet?
Assuming you're asking about page orientation... If the information is spread more sideways than vertical, you would set the page to landscape rather than portrait.
- T1: Write X // This acquires an exclusive lock: LockX
- T2: Write Y // This acquires an exclusive lock: LockY
- T2: Read X // This attempts to acquire a shared lock on X, but since X is locked already by T1, T2 is subsequently blocked by the system until X is freed.
- T1: Read Y // This attempts to acquire a shared lock on Y, but since Y is locked already by T2, T1 is subsequently blocked by the system until Y is free.
- T1: Commits // This should release all locks held by T1.
- T2: Commits // This should release all locks held by T2.
* Note that "block" means the transaction will not proceed until the specified condition is met.
Now, since T2 is waiting for T1 to free X AND T1 is waiting for T2 to free Y, we get into a cycle of condition checking. These conditions will never be met because both transactions are waiting for the other one to do something, in order to proceed itself. Therefore we have a deadlock between T1 and T2 trying to access the shared resources X and Y.
The Wikipedia article on Two-phase locking may help you understand why this is strict 2-phase locking and what 2-phase locking is.
Describe two alternatives for specifying structural constraints on relationship types?
funny if i know the answer then why i search the answer of this question.
Do you have inner join command in oracle?
yes, we do have inner join command in oracle. Inner Join is used to combine related tuples from two relations.It allows to evaluate a join condition between attributes of the relations on which join is undertaken .
I can help you with that. In my case, I had neither experience nor certification. Currently I am a database administrator making $70,000/yr. How? The key is in the title "Database Administrator." What does it mean? As it turns out it has two definitions:
1) a person who maintains a database server, the hardware and software that the database runs on, administers its users access rights, and tunes its performance for the many different users of the server 2) a person who creates databases, tables, views, and SQL statements and links those databases and tables with other technology (like web sites) (as a back-end developer), and reporting tools (like Crystal Reports or Excel, or what-have-you). I am the 2nd kind. I found my job through the government as a contractor. I do not think I could have landed the job myself, though; the secret is that a normal civilian cannot apply for a government contract and expect to win it. Instead, get hired with a contracting company that already owns those contracts and needs people to fill them. That is where the money is.
Good luck! May you find job karma.
What is material balance in sponge iron production?
Material balance in sponge iron is nothing but calculating input chargeing material into the roatary kiln comparing to the output.
Output refers the DRI,Gases,Ash,Char,Dolo Char,Lumps,Fines
BHQ if Iron ore is used
What is the different between single and double in database?
Single allows a whole integer (IE: 1,2,3,4 etc)
Double allows integers with decimal points, by storing them as two numbers internally (IE 3.12, 5.54 etc)
Where assignments will be stored in pega rules database?
Workbasket assignments are stored in pc_assign_workbasket. Worklists assignments are stored in p_assgn_worklist.
Write command to show all files and directories?
If you want everything, start at the root directory and issue the command:
ls -R
What is the difference between a column constraint and a table constraint?
column constraint is for a single column. table constraint is for an entire table.
What sets you apart from other candidates?
The way that you are apart from others is by your CANDIDATE NUMBER. :)
Can you show me a picture of a computer with its keys and its functions?
For Keyboard functions follow this link:
http://msdn.microsoft.com/en-us/library/ms907593.aspx
For Keyboard picture follow this link:
http://www.unotron.com/US/images/keyboard_plan2.jpg
well, the formula for working out volume of a cylinder is PiR^2
which means pie times the radius squared, that gets you one face then you times that by the length so the forumal is R
pR2xL where R is the radius and L is the length.
Or
Volume= Bh
B= the area of the bases
h= the height
