Terms in this set (19)
Students also viewed
Other sets by this creator
Using the notation developed for nested relations and relations with references, give one or more relation schemas that represent the following information. In each case, you may exercise some discretion regarding what attributes of a relation are included, but try to keep close to the attributes found in our running movie example. Also, indicate whether your schemas exhibit redundancy, and if so, what could be done to avoid it.
- Movies, with the usual attributes plus all their stars and the usual information about the stars.
- Studios, all the movies made by that studio, and all the stars of each movie, including all the usual attributes of studios, movies and stars.
- Movies with their studio, their stars, and all the usual attributes of these.
Recommended textbook solutions
Human Resource Management15th Edition•ISBN: 9781337520164John David Jackson, Patricia Meglich, Robert Mathis, Sean Valentine
Clinical Reasoning Cases in Nursing7th Edition•ISBN: 9780323527361Julie S Snyder, Mariann M Harding
Hole's Human Anatomy and Physiology13th Edition•ISBN: 9780073378275 (15 more)David N. Shier, Jackie L. Butler, Ricki Lewis
Other Quizlet sets