Tables within a Table - SQL

Figure here is an exact copy of the one in the theory book and as before it is just an alternative way of representing some of the information conveyed by the tables in Figure (but not a recommended database design for that information).

Figure: Tables within a table

For each course, it shows the exam mark obtained by each student who took the exam for that course.

Posted Date: 1/18/2013 6:07:51 AM | Location : United States

Ask an Expert

Related Discussions:- Tables within a table - sql, Assignment Help, Ask Question on Tables within a table - sql, Get Answer, Expert's Help, Tables within a table - sql Discussions

Write discussion on Tables within a table - sql
Your posts are moderated

Write your message here..

Related Questions

Subprograms, Subprograms The PL/SQL has two types of subprograms known ... Subprograms The PL/SQL has two types of subprograms known as the procedures and functions that can take parameters and be invoked. As the following example represents, a subp

Parameter and keyword description - object types, Parameter and Keyword Des... Parameter and Keyword Description: type_name: This identifies a user-defined type specifier that is used in the subsequent declarations of the objects. AUTHID Clause:

Assigning and comparing collections, Assigning and Comparing Collections ... Assigning and Comparing Collections One collection can be assigned to other by an SELECT, INSERT, UPDATE, or FETCH statement, an assignment statement, or by a subprogram call. A

Using raise_application_error - user-defined exceptions, Using raise_applic... Using raise_application_error The Package DBMS_STANDARD that is supplied with Oracle gives language facilities that help your application to interact with Oracle. For illustra

Package - pl/sql programming, What Is a Package? The package is a sch... What Is a Package? The package is a schema object that group logically related PL/SQL items, types, and subprograms. The Packages usually have 2 parts, a specification & a bo

Theory of panspermia - origin of life, THEO R Y OF PANSPERMIA - Arrh... THEO R Y OF PANSPERMIA - Arrhenius (1908) postulated the cosmic panspermia theory that claims that organisms existed throughout the universe, and their spores, etc., could

Functions - syntax, Functions The function is a subprogram which can ta... Functions The function is a subprogram which can take parameters and be invoked. Normally, you can use a function to calculate a value. The function has 2 sections: the specifi

Manipulating individual elements - pl/sql, Manipulating Individual Elements... Manipulating Individual Elements Faraway you have manipulated an entire collection. Within the SQL, to manipulate the individual elements of the collection, and then use the ope

Defining ref cursor types, Defining REF CURSOR Types To make cursor va... Defining REF CURSOR Types To make cursor variables, you take 2 steps. At first, you define a REF CURSOR type, and then declare the cursor variables of that type. You can defin

Understanding nested tables, Understanding Nested Tables Within the data... Understanding Nested Tables Within the database, the nested tables can be considered as one-column database tables. The Oracle stores the rows of a nested table in no specific o