Extend the database, Database Management System

Now that she understands more about the benefits of databases, the play-scheme manager would like to extend the play-scheme database to include data for schools and instructors as detailed below.

The manager wants to store the name, address and phone number for each school in the play-scheme's catchment area (regardless of whether any children from the school are registered for the play-scheme).  She also wants to record which school each child attends. (Each child can only attend one school.)

Posted Date: 3/13/2013 6:50:10 AM | Location : United States







Related Discussions:- Extend the database, Assignment Help, Ask Question on Extend the database, Get Answer, Expert's Help, Extend the database Discussions

Write discussion on Extend the database
Your posts are moderated
Related Questions
Example : Search the name, department number and salary of employees drawing minimum salary in that department. SELECT ENAME, SAL, DEPTNO  FROM EMP WHERE SAL IN (SELECT MI

What is completeness constraint on generalization? Define the variation between total and partial design constraint. Give an example each.       Ans: Completeness Constraints

Every School has many teachers and many students. Each student is assigned to one school and each teacher works for one school only. Each teacher teaches more than one subject but

What is Data Storage? The storage structures and access methods used by database system are specified by a set of explanation in a special type of DDL called data storage-defin

What is a PROJECT operation? The project operation is a unary operation that returns its argument relation with particular attributes left out. Projection is shown by pie (π).


What is horizontal fragmentation? Horizontal fragmentation divides the relation by assuming every tuple of r to one or more fragments

#question benefits and limitations of data models..

The physical location of a record is determined by which mathematical formula that transforms a file key into a record location? The physical location of a record is determined

DROP TABLE Command: When an existing object is not needed for further use, it is always better to eliminate it from the database. To remove the existing object from the databas