MindStudy - MindStudy

Question:

Published on: 21 November, 2024

Write the rules of DBA.

Answer:

DataBase administration (DBA) is an operational or technical level function responsible for physical database design, security enforcement, and database performance. Tasks include maintaining the data dictionary, monitoring performance, and enforcing organizational standards and security.

Selection of hardware and software

- Keep up with current technological trends
- Predict future changes
- Emphasis on established off the shelf products
Managing data security and privacy
- Protection of data against accidental or intentional loss, destruction, or misuse
- Firewalls
- Establishment of user privileges
- Complicated by use of distributed systems such as internet access and client/ server technology.

Subjects

Computer Graphics and Multimedia Design and Analysis of Algorithm Compiler Design Software Engineering C Programming and Practices Mobile computing

Trending

What is functional dependency? What is the need for normalization? Explain 2^nd and 3^rd normal form with example. Consider the following relation:

EMP_PROJ { SSn, Pnumber, Hours, Ename, Pname, Plocation}

Assume { SSn, Pnumber} as primary key. The dependencies are

{SSn, Pnumber}→ Hours; SSn →Ename; Pnumber → {Pname, Plocation}.

Normalize the above relation into 2NF.

21 November, 2024

Let R (ABCDE) be a relation schema and consider the following functional dependencies F = { AB→ E, AD→B, B→ C, C →D}. Find out the candidate key.

21 November, 2024

Define a Foreign key. Why is the concept needed? How does it play a role in the join operation?

21 November, 2024

Explain View with suitable example. What is the usefulness of a view?

21 November, 2024

Let T1, T2, T3 be transactions that operate on the same data items A, B, C. Let r1(A) means that T1 reads A, w1(A) means that T1 writes A and so on for T2 and T3. Consider the following schedule: S1: r2(C), r2(B), w2(B), r3(C), r1(A), w1(A), w3(B), w3(C), r2(A), r1(B), w1(B), w2(A). Is the schedule serializable and why?

21 November, 2024

What is Midpoint ellipse drawing algorithm ?