MESSAGE
| DATE | 2014-11-24 |
| FROM | Ruben Safir
|
| SUBJECT | Subject: [LIU Comp Sci] Re: Database Management Systems: DBMS Announcement on Nov. 23
|
From owner-learn-outgoing-at-mrbrklyn.com Mon Nov 24 13:46:31 2014
Return-Path:
X-Original-To: archive-at-mrbrklyn.com
Delivered-To: archive-at-mrbrklyn.com
Received: by mrbrklyn.com (Postfix)
id 2EE25161154; Mon, 24 Nov 2014 13:46:31 -0500 (EST)
Delivered-To: learn-outgoing-at-mrbrklyn.com
Received: by mrbrklyn.com (Postfix, from userid 28)
id 17F5516115B; Mon, 24 Nov 2014 13:46:31 -0500 (EST)
Delivered-To: learn-at-nylxs.com
Received: from mailbackend.panix.com (mailbackend.panix.com [166.84.1.89])
by mrbrklyn.com (Postfix) with ESMTP id 3DBAF161154
for ; Mon, 24 Nov 2014 13:46:30 -0500 (EST)
Received: from [10.0.0.42] (unknown [96.57.23.82])
by mailbackend.panix.com (Postfix) with ESMTP id EB18912A11;
Mon, 24 Nov 2014 13:46:28 -0500 (EST)
Message-ID: <54737D4B.9030303-at-panix.com>
Date: Mon, 24 Nov 2014 13:47:39 -0500
From: Ruben Safir
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Thunderbird/31.1.0
MIME-Version: 1.0
To: Ping.Chung-at-liu.edu
Subject: [LIU Comp Sci] Re: Database Management Systems: DBMS Announcement on Nov. 23
References: <366523972.2964.1416765333285.JavaMail.bbuser-at-b-ap1b.liu.edu>
In-Reply-To: <366523972.2964.1416765333285.JavaMail.bbuser-at-b-ap1b.liu.edu>
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
Sender: owner-learn-at-mrbrklyn.com
Precedence: bulk
Reply-To: learn-at-mrbrklyn.com
On 11/23/2014 12:55 PM, Ping.Chung-at-liu.edu wrote:
> Dear DBMS Students,
> Enclosed please find a reminder for your Miniproject
> Final Exam will be held on Dec. 18, Thursday, 6 ~ 8:35PM at LLC 207 (Cook Lab), the format of Final Exam will be discussed in Class.
> Happy Thanksgivings! See you on Dec. 4.
> Best regards,
> P. T. Chung
>
>
Thank you
How do you want to display the FK and PK of the database scheme
Oracle is not friendly with this regard (to say the least)
1* select constraint_name, constraint_type, table_name,
R_CONSTRAINT_NAME from user_constraints
SQL> /
CONSTRAINT_NAME C TABLE_NAME
------------------------------ - ------------------------------
R_CONSTRAINT_NAME
------------------------------
SYS_C007007 C EMPLOYEE
SYS_C007008 C EMPLOYEE
SYS_C007009 C EMPLOYEE
SYS_C007010 C EMPLOYEE
SYS_C007011 C EMPLOYEE
SYS_C007012 C EMPLOYEE
SYS_C007013 C EMPLOYEE
SYS_C007015 C DEP_LOCATIONS
SYS_C007016 C DEP_LOCATIONS
SYS_C007017 C DEPARTMENT
SYS_C007018 C DEPARTMENT
SYS_C007019 C PROJECT
SYS_C007020 C PROJECT
SYS_C007021 C PROJECT
SYS_C007022 C DEPENDENT
SYS_C007023 C DEPENDENT
SYS_C007024 C DEPENDENT
SYS_C007025 C DEPENDENT
SYS_C007026 C DEPENDENT
PK_DEP_LOCATIONS P DEP_LOCATIONS
PK_DEPARTMENT P DEPARTMENT
PK_EMPLOYEE P EMPLOYEE
PK_PROJECT P PROJECT
PK_DEPENDENT P DEPENDENT
EM_DNO_FK R EMPLOYEE
PK_DEPARTMENT
WORKSON_ESSN R WORKS_ON
PK_EMPLOYEE
EM_SUP_FK R EMPLOYEE
PK_EMPLOYEE
DEP_LOCATIONSI_DNUMBER R DEP_LOCATIONS
PK_DEPARTMENT
DEPARTMENT_MGRSSS R DEPARTMENT
CONSTRAINT_NAME C TABLE_NAME
------------------------------ - ------------------------------
R_CONSTRAINT_NAME
------------------------------
PK_EMPLOYEE
PROJECT_DNUM_PLOCATION R PROJECT
PK_DEP_LOCATIONS
DEPENDENT_FK R DEPENDENT
PK_EMPLOYEE
31 rows selected.
|
|
