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

Functions in pl/sql, Functions   The function is a subprogram that cal... Functions   The function is a subprogram that calculates a value. The Functions and procedures are structured similar, except that the functions have a RETURN clause. You can

Oracle 11 g new features , Oracle 11 G new features associated with this re... Oracle 11 G new features associated with this release:- Enhanced ILM  - Information Lifecycle Management (ILM) has been around for the almost 10 years, but Oracle has made

Package dbms pipe in pl/sql, DBMS_PIPE: The Package DBMS_PIPE allows va... DBMS_PIPE: The Package DBMS_PIPE allows various sessions to communicate over the named pipes. (A pipe is a region of memory used by one of the process to pass information to

In out mode - parameter modes, IN OUT Mode An IN OUT parameter passes ... IN OUT Mode An IN OUT parameter passes initial values to the subprogram being called and return efficient values to the caller. Within the subprogram, an IN OUT parameter acts

Extension and and in sql, Extension and AND in SQL The theory book giv... Extension and AND in SQL The theory book gives the following simple example of relational extension in Tutorial D: EXTEND IS_CALLED ADD ( FirstLetter ( Name ) AS Initial )

Boolean values-assignments in pl/sql, Boolean Values Only the values TRU... Boolean Values Only the values TRUE, FALSE, & NULL can be assigned to a Boolean variable. For illustration, given the declaration DECLARE done BOOLEAN; the following statements

Package standard, Package STANDARD The package named STANDARD defines t... Package STANDARD The package named STANDARD defines the PL/SQL atmosphere. The package specification globally declares the exceptions, types, and subprograms that are available

Obtaining a natural join by specifying the common columns, Obtaining a natu... Obtaining a natural join by specifying the common columns Synatax: SELECT * FROM IS_CALLED JOIN IS_ENROLLED_ON USING ( StudentId ) However, a named columns join doe

Oracle 10g new features and differences , Oracle 10G new features:- Au... Oracle 10G new features:- Automatic Database Diagnostic Monitor System Advancements - these methods will provides several methods for extracting reports through the Automatic

Enrolment was split - sql, Enrolment was split - SQL Example shows ho... Enrolment was split - SQL Example shows how relvars IS_CALLED and IS_ENROLLED_ON can be derived from the original ENROLMENT relvar, using projection in the initial assignment