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

Important distinctions, Important Distinctions The list of important d... Important Distinctions The list of important distinctions are given below: Value versus variable Syntax versus semantics Variable versus variable reference

%isopen - implicit cursor attributes, %ISOPEN The Oracle closes the SQ... %ISOPEN The Oracle closes the SQL cursor automatically after executing its related SQL statement. As a result, the %ISOPEN forever yields FALSE.

Out mode - parameter modes, OUT Mode An OUT parameter returns values t... OUT Mode An OUT parameter returns values to the caller of a subprogram. Within the subprogram, an OUT parameter act like a variable. That means that you can use an OUT formal

Deleting objects in pl sql, Deleting Objects You can use the DELETE st... Deleting Objects You can use the DELETE statement to eradicate objects from an object table. To eradicate objects selectively, you use the WHERE clause, as shown below: BEG

Example of not exists operator - sql, Example of NOT EXISTS Operator - SQL ... Example of NOT EXISTS Operator - SQL Example is a translation into SQL of the corresponding example, which is included there merely to show that for any scalar comparison the

Sql, Write a cursor to open an employee database and fetch the employee rec... Write a cursor to open an employee database and fetch the employee record whose age is greater than 45

Types of evolution, TYPES OF EVOLUTION - Sequential evolution         ... TYPES OF EVOLUTION - Sequential evolution                  :                    Minor changes in the gene pool of a population from one generation to the next, with the resul

Data types in sql - interval, Data Types in SQL - Interval, Boolean I... Data Types in SQL - Interval, Boolean INTERVAL for values denoting, not intervals (!) but durations in time, such as 5 years, 3 days, 2 minutes, and so on. BOOLEAN, con

%rowcount, %ROWCOUNT When its cursor or cursor variable is opened, the... %ROWCOUNT When its cursor or cursor variable is opened, the %ROWCOUNT is zeroed. Before the first fetch, the %ROWCOUNT yields 0. Afterward, it yields the number of rows fetche

Using aggregation on nested tables - sql, Using Aggregation on Nested Table... Using Aggregation on Nested Tables Example is the most direct translation of its counterpart in the theory book that can be obtained in SQL but it is so over-elaborate that no