d has 10 tuples per block Relation S contains 10,000 tuples and has 10 tuple

Consider that a database contains the following relations  PARENT(X, Y), and a relation BIRTH(X, B), where B is the birthdate of a person X. The following information is used for question (b), (c)  that we have the following family tree

Let R(A, B, C) be arelational schema with the following functional dependencies :{A— >B,B—>C,C— >A}The decomposition of Rinto (A, B), (B, C).A. Gives a lossless join, and is dependency preservingB. Gives a lossless join, but is not dependency preservingC. Does not give a lossless join, but is dependency preservingD. Does not give a lossless join and is not dependency preserving

Course: Principles of Database   please solve it within 30 minutes. please please, pleaseThank you Single Choice Questions 11. Given a relation R and a condition f for selecting from relation R, the correct relational algebraic expression is (    ). A、R X R             B、 R ⋈ R        C、sf(R)                 D、 ∏f(R) 12. If relations R and S have a common attribute set Y, when executing , tuples that do not have matching values on attribute Y will be discarded. To avoid discarding those tuples, which operation should be used? (    ) A. Aggregation.                        B. Grouping. C. Outer union.                        D. Outer join. 13. To address the "lost update" problem, a transaction must obtain (    ) before updating a data set. A. Shared lock (S-lock).               B. Exclusive lock (X-lock). C. Shared lock (S-lock) and exclusive lock (X-lock). D. Shared lock (S-lock) or exclusive lock (X-lock). 14. If, during the system operation, data stored on external storage is…

QUESTION 7 Consider the following database schema for University Library database. A student can borrow many books and a given book can be borrowed by any student if it is available in the library. For each borrowing, the borrowing and return dates are registered in the database. Student (SID: long, CPR:long (unique), Name:string, tel:number, major:String, gender:Character {"F' or M'}) Book (ISBN:long, Title:string (unique), Author:string) Borrowedltems(stSID:long, booklSBN:long, serialNo.int (unique), BorrowingDate:date, RetumDate:date) Write SQL statements to: 1. List ISBN, Title, Author of all books that include the word 'Database' in their titles in a descending order of ISBN. 2. List SID, Name, and Major of all female students doing major in 'CS' and their name starts with 'S'.

Consider the following relational database

Read Scnerio carefully :  Make a Propose and optimal database design in RDBMS for a super store. In which clients came and can purchase products according to their likes and dislikes. Super store have same products of different companies. In the end client received a receipt of their purchase from counter he/she go for bill. Database also save records of stock according to FIFO system. Required to define Entities and their attributes Attributes Types  Each Attribute Required  Define keys of each entity Define relationship between the entities.

Let R and K be two relations under a join operation. Assume that m = |R| and n = IKI, then the maximum and minimum sizes of the join, respectively, are: 1. m+n and 0 II. mn and 0 III. m+n and m-n IV. mn and m+n III O IV =

Make a hybrid merge-join variant that works in scenarios where neither relation is physically sorted but has a sorted secondary index on the joined attributes.

A column in a relation (table) has a type. Consider implementing a date as CHAR(10) in the format YYYY-MM-DD. The lecture material states that attributes (column values) come from a domain. Using date explain the differenc between a domain and a type.