Mon Mar 8 19:28:43 2021
EVENTS
 FREE
SOFTWARE
INSTITUTE

POLITICS
JOBS
MEMBERS'
CORNER

MAILING
LIST

NYLXS Mailing Lists and Archives
NYLXS Members have a lot to say and share but we don't keep many secrets. Join the Hangout Mailing List and say your peice.

DATE 2014-11-01

LEARN

2021-03-08 | 2021-02-08 | 2021-01-08 | 2020-12-08 | 2020-11-08 | 2020-10-08 | 2020-09-08 | 2020-08-08 | 2020-07-08 | 2020-06-08 | 2020-05-08 | 2020-04-08 | 2020-03-08 | 2020-02-08 | 2020-01-08 | 2019-12-08 | 2019-11-08 | 2019-10-08 | 2019-09-08 | 2019-08-08 | 2019-07-08 | 2019-06-08 | 2019-05-08 | 2019-04-08 | 2019-03-08 | 2019-02-08 | 2019-01-08 | 2018-12-08 | 2018-11-08 | 2018-10-08 | 2018-09-08 | 2018-08-08 | 2018-07-08 | 2018-06-08 | 2018-05-08 | 2018-04-08 | 2018-03-08 | 2018-02-08 | 2018-01-08 | 2017-12-08 | 2017-11-08 | 2017-10-08 | 2017-09-08 | 2017-08-08 | 2017-07-08 | 2017-06-08 | 2017-05-08 | 2017-04-08 | 2017-03-08 | 2017-02-08 | 2017-01-08 | 2016-12-08 | 2016-11-08 | 2016-10-08 | 2016-09-08 | 2016-08-08 | 2016-07-08 | 2016-06-08 | 2016-05-08 | 2016-04-08 | 2016-03-08 | 2016-02-08 | 2016-01-08 | 2015-12-08 | 2015-11-08 | 2015-10-08 | 2015-09-08 | 2015-08-08 | 2015-07-08 | 2015-06-08 | 2015-05-08 | 2015-04-08 | 2015-03-08 | 2015-02-08 | 2015-01-08 | 2014-12-08 | 2014-11-08 | 2014-10-08

Key: Value:

Key: Value:

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.


  1. 2014-11-08 Ruben <ruben.safir-at-my.liu.edu> Subject: [LIU Comp Sci] Re: Welcome to learn
  2. 2014-11-08 Ruben <ruben.safir-at-my.liu.edu> Subject: [LIU Comp Sci] second post!!
  3. 2014-11-22 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Oracle Files for the Homework and Oracle Resources
  4. 2014-11-22 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Oracle Webineir on pl/sql
  5. 2014-11-22 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] UEFI and Secure Boot
  6. 2014-11-24 Ruben <ruben.safir-at-my.liu.edu> Re: [LIU Comp Sci] Oracle DBA short cuts
  7. 2014-11-24 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Oracle DBA short cuts
  8. 2014-11-24 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Re: Database Management Systems: DBMS Announcement on Nov. 23
  9. 2014-11-26 Ruben Safir <mrbrklyn-at-panix.com> Re: [LIU Comp Sci] Problems with Normalization
  10. 2014-11-26 Ruben <ruben.safir-at-my.liu.edu> Subject: [LIU Comp Sci] =?UTF-8?B?UmU6IERhdGFiYXNlIE1hbmFnZW1lbnQgU3lzdGVtczogQ1MgNjQ5IEE=?=
  11. 2014-11-26 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] More problems with modeling and normalization
  12. 2014-11-26 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Normalize because your professor said too
  13. 2014-11-26 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Problems with Normalization
  14. 2014-11-26 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Why Data Models Shouldn't Drive Object Models (And Vice Versa)
  15. 2014-11-26 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Why Normalization Failed to Become the Ultimate Guide for Database
  16. 2014-11-29 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Memory Cache theory Architecture Class
  17. 2014-11-30 Ruben Safir <mrbrklyn-at-panix.com> Subject: [LIU Comp Sci] Cache Model in C programming

NYLXS are Do'ers and the first step of Doing is Joining! Join NYLXS and make a difference in your community today!