Database management

Pages 1 (251 words)
Download 0
1B. The relational model for the above ER Diagram is given, hereunder:
CREATE TABLE student (
studentid number primary key,
name varchar(30),
address varchar(30),
streamid number references streams(streamid)


2B. The Relational model for the above ERD follows :
CREATE TABLE players (
playerid number primary key,
name varchar(30),
bdate date,
schoolid number references school(schoolid),
yr_joined number,
grad_school number references school(schoolid)

Download paper
Not exactly what you need?

Related papers

Database Management System
The following assumptions are derived from the above diagram: 1. The pointer with arrow head shows the dependent variable and the pointer with no arrow head shows the determinant variable. 2. There are 3 functional dependencies as shown above in the diagram.
2 pages (502 words)
Library Database Management System Logical & Physical Database Design- Normalise the Schema to BCNF (normalisation)
2 pages (502 words)
Database Management: Application in School Environment
It allows us to access our Microsoft Access database and any other ODBC compliant data source. The various departments who have access and benefiting from these database are the following:…
2 pages (502 words)
Database Management System
It is essential or the organization to develop an effective database system. Database is defines as a system, used to record and maintains data. The most important point to understand database is that database contains data and not necessarily information. The database is a collection of interrelated data, which can be used by one or more applications that it can be integrated and is stored in a…
6 pages (1506 words)
Database management Coursework
select distinct Customer.CustNo, Customer.CustFirstName, Customer.CustLastName, Customer.CustBal from Customer, OrderTbl where Customer.CustNo = OrderTbl.CustNo and (OrderTbl.OrdDate between '01-Feb-2007' and '28-Feb-2007);…
7 pages (1757 words)
Database Management. MSSQL Server Database.
In this case the university requirements deal with a variety of services which requires their data to be stored in a database so that it can be successfully fetched and modified for performing a variety of functions. …
3 pages (753 words)