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
Describe the Composite Key Composite Key: Sometimes one key is not enough to uniquely recognize a row. E.g. in a single class Roll is enough to search a student, but in the w

what is Nested relational model? Explain with examples.

Explain Hierarchical Model ? Hierarchical Model - It was established to model several kinds of hierarchical organizations which exist in the real world. It uses tree structur

Define query optimization. Query optimization refers to the process of search the lowest -cost method of evaluating a given query.

Create centralized relational database using bottom up method.   (a) Recognize a single un-normalized relation for the above scenario.          (b) Recognize the primary key for

Structure of Client Server Systems: In client/server architecture, clients show users who require services while servers give services. Both client and server are a combination of

why shadow copy technique is used?

Define in which normalisation form if an attribute of a composite key is dependent on an attribute of other composite key. Ans: 3NF A relation is in 3 NF if an attribute of

Which language used in application programs to request data from the DBMS is referred? Language which is used in application program is DML to request data from the DBMS is ref