3Nf Is given im 2nd PiC

Q4. Conser the database schema in 3NF for the "Movie" database Post obtail . Now write down queries in relational algebra for each of the Tuig conditions. [10] i. A query which extracts two attributes (using projection operator) from a single relation, based on at least one condition (using selection operator). ii. A query which extracts two attributes from two relations, which are joined using Cartesian product operator. The rows must be filtered based on at least one condition (using selection operator). iii. A query which extracts two attributes from two relations, which are joined using theta-join operator in relational algebra. The rows must be filtered based on at least one condition. iv. A query which extracts three attributes from three relations, which are joined using theta-join operator in relational algebra. The rows must be filtered based on at least two conditions. v. A query which extracts two attributes from two relations, which are joined using left-outer-join operator in relational algebra. The rows must be filtered based on at least one condition. INF. Author Name Author DOB company company Name address director i director Name | DOB Q2. Answer the following I. What are the two category of printers in short? II. What is NIC in term of Computers? Q3. Answer the following I. How to create new file in MS dos? II. Explain the following MS dos commands. (a) Attrib (b) Ran (c) MD (D) Xcopy RD Q4 Explain the following a) Topology b) communication model c) Fiber optics d) different between LAN and MAN Q5) Perform the following number system conversation. i. (435)8 = ( ? )16 ii. (8D1)16 = (?) Convert the following octal number into binary and hexadecimal iii. (365517): = ( ? )2 = ( ? )16 iv) (45316.7414)= (?)2 = ( ? )16 Q6) Define the following with example. I. High level language vs low level language. II. Machine language vs Assembly language. III. Compiler vs interpreter. Procedural language vs non procedural language. IV. Covert the following binary to Decimal than to Hexadecimal v. (10100.1101)2 = (?)10 = (?)16