|
|
Browse by Tags
- database
- Database Logic
- db
- db design
- db diagram
- ddl script
- diagram
- er diagram
- normalization
- normalizations
- oracle
- rdbms
- relationships
- reporting
- sql
- SQL Query
- sql script
- SQL Server 2005
- SQL SERVER 2005 REPORTING SERVICES
-
One to One Relationship and ON DELETE CASCADE - RDBMS Design
Customer and CustomerPrivateInfo are meant to be one to one relationship. If CustomerPrivateInfo record is attempted to be deleted, prevent deletion. If Customer record is deleted, delete its associated CustomerPrivateInfo. Does the DDL below fulfill my request? I'm using Oracle... Code Snippet:... -
How to Draw Diagram for My Database Design?
I find database designs get the db designer mixed up/confused in some point of designing. Is there a certain diagram flow that is commonly known amongst designers? When i design a database, it comes to a point i feel i want to put them all in one sheet of paper so i can know what goes in and what goes... -
Simple Question About RDBMS Design - SQL - I Need Suggestion
http://img3.imageshack.us/img3/6989/53645000.jpg Beside CustomerFamilyMembers entity you will see (0,6). This means a customer does not need to have a family in case a customer is single. However, in case a customer has a family, the family members can not exceed 6 members. If i did (1, 6), this means... -
SQL*Plus Error While Running a DDL Script - Oracle
I have DDL Script. When i run every table DDL script individually, tables gets created. However, when i run the whole script by doing: SQL> @C:\Users\Home_User\Desktop\motel_db_schema.sql I got error for one the tables which screws up all the child tables too. This is the error i get: SP2-0734: unknown... -
Why Can't I Use Currval in Select Statement? - Oracle
I was trying to do SELECT employeename, job_id_seq.CURRVAL FROM employees; I got an error. Can't i call CURRVAL of a sequence via SELECT like above? Why? I know it would work if i do it on DUMMY table. Can i use name.CURRVAL via INSERT INTO? Why? -
Can I Put CREATE SEQUENCE - NEXTVAL Within CREATE TABLE - Oracle?
I created some sequences. I would like to indulge into the primary key column in CREATE TABLE script. How can i do it? -
Simple Question About INSERT INTO Using Select Query - Oracle
INSERT INTO CustomerFamilyHistory (customerfamilyhistory_id_seq.nextval, firstname, lastname, age, ?????, sibling, customerid) SELECT customerfamilymemberfirstname, customerfamilymemberlastname, customerfamilymemberage, customerfamilymembersibling, cusfamilymembcustomerID FROM CustomerFamilyMember; Insert... -
Please Check My Simple DDL Script - Fix Mistakes If Any
Is it ok to do CHECK (leavingdate >= hiredate)? I don't have the tools yet to check my script. Code Snippet: 1: 2: 3: 4: 5: 6: 7: 8: 9: CREATE TABLE EmployeeHistory ( employeehistoryid number(10) CONSTRAINT employeehistoryid_pk PRIMARY KEY, salary number(9,2) NOT NULL, motelname varchar2(50) NOT... -
Designing Quiz Database - I Need Suggestion - SQL RDBMS
My question is: Before i go any further, please let me know if you think my database entity structure is ok. If its not well put, i would like to know why. General Note: I'm not after the implementation process yet. I still have to make the attributes, domain, normalization, and relationships. I'm... -
Primary Key and Foreign Key - SQL RDBMS Simple Question
works_on table has primary key: essn and pno dependent table has primary key: essn and dependent_name. essn is a foreign key that references to works_on table. When i run, i get this error: ORA-02270: no matching unique or primary key for this column-list Cause: A REFERENCES clause in a CREATE/ALTER...