Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Filter
ibia
Wall
Recent activity
All questions
All answers
Exams Taken
All Blogs
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.
Specify the following queries in SQL on the database schema of Figure 1.2.Figure 1.2:A database that storesstudent and courseinformation.CaptionRetrieve the names of all ...
1.4k
views
asked
Apr 7, 2016
Databases
descriptive
databases
sql
navathe
+
–
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
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 databas...
3.5k
views
asked
Apr 6, 2016
Databases
databases
descriptive
sql
navathe
+
–
1
votes
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
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 databa...
770
views
asked
Apr 5, 2016
Databases
databases
descriptive
sql
navathe
+
–
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.
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 ...
469
views
asked
Apr 5, 2016
Databases
databases
descriptive
sql
navathe
+
–
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.
Write appropriate SQL DDL statements for declaring the LIBRARY relational database schema of figure below. Specify the keys and referential triggered actions.
1.1k
views
asked
Apr 4, 2016
Databases
databases
sql
+
–
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.
List the data types that are allowed for SQL attributes.
381
views
asked
Apr 2, 2016
Databases
databases
sql
descriptive
+
–
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
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 referenti...
1.0k
views
asked
Apr 2, 2016
Databases
databases
referential-integrity
navathe
descriptive
+
–
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
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 $SQ...
518
views
asked
Apr 1, 2016
Databases
databases
referential-integrity
navathe
descriptive
+
–
41
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.
Consider the following first order formula:$\left ( \matrix{ \forall x \exists y : R(x,y) \\[1em] \Large \land \\[1em] \forall x \forall y : \left ( R(x,y) \impl...
6.2k
views
asked
Nov 16, 2015
Mathematical Logic
gate1991
mathematical-logic
first-order-logic
descriptive
+
–
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.
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 $...
765
views
asked
Nov 14, 2015
Digital Logic
gate1991
digital-logic
sequential-circuit
shift-registers
out-of-gate-syllabus
+
–
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.
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 $...
22.9k
views
asked
Nov 14, 2015
Digital Logic
gate1991
digital-logic
sequential-circuit
flip-flop
digital-counter
+
–
20
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.
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...
3.2k
views
asked
Nov 14, 2015
Digital Logic
gate1991
digital-logic
boolean-algebra
min-sum-of-products-form
descriptive
+
–
4
votes
3
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 ____________
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 n...
1.7k
views
asked
Nov 14, 2015
Compiler Design
gate1991
compiler-design
register-allocation
out-of-gate-syllabus
+
–
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________
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________
1.5k
views
asked
Nov 13, 2015
Combinatory
number-theory
+
–
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register