data warehousing

| |

Entity Relationship Diagram – ERD and Cardinality Symbols Simple Explanations

Understading cardinality notation and being able to explain them will go a long way in your database design and implementation. Here we look at a simple explanation of the symbols. (Credit to Data Warehousing for Business Intelligence by University of Colorado System on Coursera) Symbols in the above diagram and their meanings: – Oval: means 0 –…

|

Creating Oracle PL/SQL Tables for Intercollegiate Athletic Database – Data Warehousing

Creating Oracle  tables for Intercollegiate Athletic Database. Part of Assignment one of Data Warehousing for Business Intelligence on Coursera –1 CREATE TABLE FACILITY CREATE TABLE FACILITY( FACNO VARCHAR(12), FACNAME VARCHAR(255) NOT NULL, CONSTRAINT PK_FAC PRIMARY KEY (FACNO) ); –2.REATE TABLE EMPLOYEE CREATE TABLE EMPLOYEE( EMPNO VARCHAR(12), EMPNAME VARCHAR(255) NOT NULL, DEPARTMENT VARCHAR(100) NOT NULL, EMAIL VARCHAR(50) NOT…