Questions by ibia

0 votes

1 answer

1

Navathe-Fundamentals of Database systems-basic SQL-sixth edition-4.12
Specify the following queries in SQL on the database schema of Figure 1.2. Figure 1.2: A database that stores student and course information.Caption Retrieve the names of all senior students majoring in ‘CS& ... name, course number, credit hours, semester, year, and grade for each course completed by the student.

asked in Databases Apr 7, 2016

1.2k views

0 votes

0 answers

2

Navathe-Fundamentals of Database systems-basic SQL-sixth edition-4.10
Specify the following queries in SQL on the COMPANY relational database schema shown in figure 3.5 .Show the result of each query if it is applied to the COMPANY database in Figure 3.6 Retrieve the ... for the COMPANY relational database schema. FIGURE 3.6:One possible database state for the COMPANY relational database schema

asked in Databases Apr 6, 2016

2.9k views

1 vote

0 answers

3

Navathe-Fundamentals of Database systems-basic SQL-sixth edition-4.11
Specify the updates of Exercise 3.11 using the SQL update commands. EXERCISE 3.11 : Suppose that each of the following Update operations is applied directly to the database state shown in Figure 3.6. Discuss all integrity ... Michael M 1988-01-04 Son 123456789 Alice F 1988-12-30 Daughter 123456789 Elizabeth F 1967-05-05 Spouse

asked in Databases Apr 5, 2016

627 views

0 votes

0 answers

4

Navathe-Fundamentals of Database systems-basic SQL-sixth edition-4.14
Design a relational database schema for a database application of your choice. Declare your relations,using the SQL DDL. Specify a number of queries in SQL that are needed by your database application. Based on your ... that should have indexes specified on them Implement your database , if you have a DBMS that supports SQL.

asked in Databases Apr 5, 2016

372 views

2 votes

0 answers

5

Navathe-Fundamentals of Database systems-basic SQL-sixth edition-4.8
Write appropriate SQL DDL statements for declaring the LIBRARY relational database schema of figure below. Specify the keys and referential triggered actions.

asked in Databases Apr 4, 2016

882 views

0 votes

1 answer

6

Navathe-Fundamentals of Database systems-basic SQL-sixth edition-4.2
List the data types that are allowed for SQL attributes.

asked in Databases Apr 2, 2016

256 views

0 votes

0 answers

7

Navathe-Fundamentals of Database systems-basic SQL-sixth edition-4.7
Consider the LIBRARY relational database schema shown in the figure below .Choose the appropriate action (reject, cascade, set to NULL, set to default) for each referential integrity constraint, both for the deletion of a referenced tuple and for the update of primary key attribute value in a referenced tuple.Justify your choices

asked in Databases Apr 2, 2016

854 views

0 votes

0 answers

8

Navathe-sixth edition-4.5
Consider the database shown below ,Whose schema is also shown below .What are the referential integrity constraints that should hold on the schema ? Write appropriate $SQL$ $DDL$ ... Credit_hours Department PREREQUISITE Course_number Prerequisite_number SECTION Section_identifier Course_number Semester year Instructor GRADE_REPORT Student_number Section_identifier Grade

asked in Databases Apr 1, 2016

356 views

37 votes

4 answers

9

GATE CSE 1991 | Question: 15,b
Consider the following first order formula: ... Does it have finite models? Is it satisfiable? If so, give a countable model for it.

asked in Mathematical Logic Nov 16, 2015

4.8k views

5 votes

0 answers

10

GATE CSE 1991 | Question: 6,b
Design a $1024$ bit serial-in/serial-out unidirectional shift register using a $1K\times 1 $bit RAM with a data input $D_{in}$, data output $D_{out}$ and control input $\text{READ}/\overline{\text{WRITE}}$. You may assume the availability of standard SSI and MSI components such as gates, registers and counters.

asked in Digital Logic Nov 14, 2015

622 views

53 votes

5 answers

11

GATE CSE 1991 | Question: 5-c
Find the maximum clock frequency at which the counter in the figure below can be operated. Assume that the propagation delay through each flip flop and each AND gate is $10\;\text{ns}$. Also, assume that the setup time for the $JK$ inputs of the flip flops is negligible.

asked in Digital Logic Nov 14, 2015

19.4k views

19 votes

2 answers

12

GATE CSE 1991 | Question: 5-b
Find the minimum sum of products form of the logic function $ f(A,B,C,D) = \Sigma_{m}(0,2,8,10,15)+ \Sigma _{d}(3,11,12,14)$ where $m$ and $d$ represent minterm and don't care term respectively.

asked in Digital Logic Nov 14, 2015

2.7k views

4 votes

2 answers

13

GATE CSE 1991 | Question: 01,xi
The arithmetic expression $(a+b) * c- d/e ** l$ is to be evaluated on a two address machine, where each operand is either a register or a memory location. With a minimum number of memory accesses of operands.the number of registers required to evaluate this expression is ______. The number of memory accesses of operands is ____________

asked in Compiler Design Nov 14, 2015

1.3k views

10 votes

2 answers

14

GATE1991-01,xiii
The number of integer-triples $(i,j,k)$ with $1 \leq i,j,k \leq 300$ such that $i+j+k$ is divisible by 3 is________

asked in Combinatory Nov 13, 2015

1.4k views

tags	tag:apple
author	user:martin
title	title:apple
content	content:apple
exclude	-tag:apple
force match	+apple
views	views:100
score	score:10
answers	answers:2
is accepted	isaccepted:true
is closed	isclosed:true

Questions by ibia

Subscribe to GATE CSE 2024 Test Series

Subscribe to GO Classes for GATE CSE 2024

Subjects

Questions by ibia

Subscribe to GATE CSE 2024 Test Series

Subscribe to GO Classes for GATE CSE 2024

Recent Posts

Subjects

Recent Blog Comments