convert erd to rdm model, Database Management System

Regional Gardens has many nurseries, including Wagga Wagga, Bathurst, Albury, Orange, and Dubbo. Each nursery is known by its campus code, eg WW, B, A, O and D respectively. Additionally a unique nursery id is assigned to each nursery. Staff members are usually located at one nursery, but may move to another nursery on occasion.

Attributes to be included in the relational tables are nursery_name, nursery_id, nursery_address, nursery_code, staff_id, staff_fname, staff_lname, staff_employ_date.


Posted Date: 4/3/2013 5:03:57 AM | Location : Australia







Related Discussions:- convert erd to rdm model, Assignment Help, Ask Question on convert erd to rdm model, Get Answer, Expert's Help, convert erd to rdm model Discussions

Write discussion on convert erd to rdm model
Your posts are moderated
Related Questions
Ask questiwhat is row indicator in database on #Minimum 100 words accepted#

Multilevel Index The Multilevel Index is a modification of the secondary level index system. In this system we might be use even more number of levels in case the table is eve

For every n-ary relationship type R where n>2, we make a new table S to represent R. We contain as foreign key attributes in s the primary keys of the relations that show the parti

Describe the static hash file with buckets and chaining and show how insertion, deletion and modification of a record can be performed. In static hash file organization, the wo

The database will enable college administrators the ability to track students initial major. This will help college officials decide how best to prepare students for their goals an

What is magnetic disks?explain it? Magnetic disk provides the bulk of secondary storage of modern computer system. The disk capacity is growing at over 50% per year. But the st


Define the Third Normal Form: The third normal form (3NF) is a normal form employed in database normalization. 3NF was initially defined by E.F. Codd in 1971. Codd's definitio

Define Cascading rollback The phenomenon where a single transaction failure leads to a series of transaction rollbacks is known as Cascading rollback.

What are the situations while DBMS should not be used? DBMS should not be used in situations like: (i) No need of security. (ii) Not difficulty to access the data (iii) N