Developing Entity Relationship Diagrams (ERDs)
Entity Relationship Diagrams are a major data-modeling tool and will help
organize the data in your project into entities and define the relationships
between the entities. This process has proved to ena
Data Definition Language (DDL) Statements
create table emp (empno number(5) primary key,
Now Suppose you have emp table now you want to create a TAX ta
Conceptual data modeling
Logical database design
ENTITY RELATIONSHIP MODEL
In Software Design the way UML diagrams are going
to play the role, in Database design ER diagrams are
going to play the role for it.
ENTITY RELATIONSHIP MODEL is the conceptual
model by which we conceive structure of database,
To Be Submitted by 30th Sep 2014 (Tuesday)
List Codds 12 rules for a relational database
Create Entity-Relation (E-R) Matrix and E-R Diagram for the given problem definition
given below on Railway reservation
Oracle 9i DBA Lab
Date:- 29th Sep 2014
Case Study: - LIBRARY DATABASE
Create Database with SID Library.
Add Database To Tree.
Create User:Set up a user named practice, with a password of practice. Give this user CONNECT and RESOURCE.
Open two windows comm
ASSINGMENT OF FIRST HALF DAY FOR 3rd CLASS
Create a table name Employee with the following attributes (with primary key and foreign key)
(Emp_id (PK), FNAME, LNAME, Email, Gender, PhoneNo, HireDate, JOBID, Salary, Commision_PCT,
PL/SQL Day 1
Evaluate each of the following declarations.
Determine which of them are not legal and explain why?
DECLARE v_id NUMBER(4);
DECLARE v_x , v_y, v_z VARCHAR2(10);
DECLARE v_birthdate DATE NOT NULL;
For every Strong Entity Type, a Relation is
created such that it includes all the attributes
present in Entity
A key attribute is made Primary Key (unique)
For Example, empid in Employee Entity