Ask a question from expert

Ask now

ISYS1055 - Database Concepts | Assignment

14 Pages1619 Words106 Views
   

Royal Melbourne Institute of Technology

   

Database Concepts (ISYS1055)

   

Added on  2020-03-01

About This Document

The below document discusses the various database concepts. The various questions which have been discussed related to the database are " The Relational database", " SQL"and "ERD".

ISYS1055 - Database Concepts | Assignment

   

Royal Melbourne Institute of Technology

   

Database Concepts (ISYS1055)

   Added on 2020-03-01

BookmarkShareRelated Documents
Student NameStudent Id1Assignment 1: Database ConceptsSubmitted ByCourseProfessorDate
ISYS1055 -  Database Concepts | Assignment_1
Student NameStudent Id2Answer 1 – The Relational ModelCreate Table1. EmployeeSQL> create table Employee (empNo varchar2(5) primary key, givename varchar2(30), famname varchar2(30), gender char(1), DOB date);2. DeptSQL> create table Dept (deptNo varchar2 (5) primary key, name varchar2(30), manager_empNovarchar2(5) references Employee(empNo));
ISYS1055 -  Database Concepts | Assignment_2
Student NameStudent Id33. DependentSQL> create table Dependent (empNo varchar2(5), name varchar2(30), relationshipvarchar2(20), constraint pk_emp primary key (empNo, name));4. Project
ISYS1055 -  Database Concepts | Assignment_3
Student NameStudent Id4SQL> create table Project (projNo varchar2(5) primary key, description varchar2(50), deptNovarchar2(5) references Dept(deptNo));Inserting Data1. EmployeeSQL> Insert into Employee values ('1', 'James', 'Bond', 'M', to_date('23/05/1968','dd/mm/yyyy')); Insert into Employee values ('2', 'Smith', 'Citizen', 'M', to_date('11/01/1977','dd/mm/yyyy')); Insert into Employee values ('3', 'Jane', 'Smith', 'F', to_date('06/03/1998', 'dd/mm/yyyy'));
ISYS1055 -  Database Concepts | Assignment_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Entity Relationship Diagram for Ace Software, Inc.
|10
|1270
|128

Logical Database Design for Desklib
|16
|2710
|153

Implementation Process for FF4U Online Food Delivery System
|19
|1403
|88

COMP1556 - DB Applications
|19
|2645
|208

Question 1: Relational Algebra
|6
|647
|71

Relational Data Structure, Tables, Inserts and Queries
|25
|2447
|483