Register

Navathe-Fundamentals of Database systems-basic SQL-sixth edition-4.14

733 views
0 0 votes

Design a relational database schema for a database application of your choice.

  1. Declare your relations,using the SQL DDL.
  2. Specify a number of queries in SQL that are needed by your database application.
  3. Based on your expected use of database , choose some attributes that should have indexes specified on them
  4. Implement your database , if you have a DBMS that supports SQL.

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← Previous · Can Anyone tell me t...Next → · Navathe-Fundamentals...
← Previous in category · Navathe-Fundamentals...Next in category → · Navathe-Fundamentals...
Position:
Show:

Related questions

0 0 votes
1 1 answer
1.9k
1.9k views
ibia asked Apr 7, 2016
1,937 views
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 storesstudent and courseinformation.CaptionRetrieve the names of all ...
0 0 votes
0 0 answers
4.1k
4.1k views
ibia asked Apr 6, 2016
4,072 views
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 databas...
1 1 vote
0 0 answers
1.2k
1.2k views
ibia asked Apr 5, 2016
1,176 views
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 databa...
0 0 votes
0 0 answers
1.3k
1.3k views
ibia asked Apr 2, 2016
1,310 views
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 referenti...