Consider the database case of keeping record of which user is currently holding which book from...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Consider the database case of keeping record of which user is currently holding which book from a local library. Create 2 entity types Book and User and a relationship type Borrows. a) Suppose each library book needs to be recorded merely for the bookld and the book title, and each user needs to be recorded merely for the userld and the userName. Draw the diagrams for the entity types Book and User. What other attributes are likely to be useful in these entity types? b) Assume each user may borrow up to 10 books in total. Draw the full ER diagram for this simple database and also specify the occurrence multiplicities for the relationship. c) Similar to the steps in Visual track 1, use SQL Server's graphical user interface to design the tables Book, User and Borrows. Specify the respective primary keys, and enter 2-3 records into each of these tables. d) Likewise use SQL Server's GUI to display the table design and the table records for these 3 tables. e) What is the typical output or artefact generated at each of the 3 phases of database design? For the database case above, show the output/artefact for all the 3 design phases. Consider the database case of keeping record of which user is currently holding which book from a local library. Create 2 entity types Book and User and a relationship type Borrows. a) Suppose each library book needs to be recorded merely for the bookld and the book title, and each user needs to be recorded merely for the userld and the userName. Draw the diagrams for the entity types Book and User. What other attributes are likely to be useful in these entity types? b) Assume each user may borrow up to 10 books in total. Draw the full ER diagram for this simple database and also specify the occurrence multiplicities for the relationship. c) Similar to the steps in Visual track 1, use SQL Server's graphical user interface to design the tables Book, User and Borrows. Specify the respective primary keys, and enter 2-3 records into each of these tables. d) Likewise use SQL Server's GUI to display the table design and the table records for these 3 tables. e) What is the typical output or artefact generated at each of the 3 phases of database design? For the database case above, show the output/artefact for all the 3 design phases.
Expert Answer:
Related Book For
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George
Posted Date:
Students also viewed these databases questions
-
I have created the variables noisy value and noisy sqft which have random noise added to the actual variables. Take a look at the relationship between these variables by creating a variable equal to...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
To demonstrate the ability to propose, implement, and query the database. Problem: MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and Arizona....
-
Find the deflection y(x) of a cantilever beam embedded at its left end and free at its right end when the load is as given in Example 10.
-
Saturated liquid nitrogen at 500 kPa enters a SSSF boiler at a rate of 0.005 kg/s and exits as saturated vapor. It then flows into a super heater also at 500 kPa where it exits at 500 kPa, 275 K....
-
Determine value of K1 for some cases listed in Appendix 4B for the following values: (a) Centre-cracked plate under uniform tension; 2a = 60 mm, 2W = 140 mm, <1= 150 MPa. (b) Single-edge-notch three...
-
A salespersons past and present performances affect his or her expectations for future performance. After experiencing several failures, many new salespeople quit their sales job within a few months...
-
What type of user interface will you design for the sales clerks? Before you come to your solution, do a careful analysis in three paragraphs that compares and contrasts various user...
-
Accounting for Fair Value Hedge: Put Option PierTwo purchased at par 100 $100 5% bonds of Supplier Inc. on January 1. To avoid exposure to fluctuations in the fair value of Supplier Inc. bonds,...
-
Penny Stafford, the owner of Belvi Coffee and Tea Exchange, located in Bellevue, Washington, brought an antitrust suit against Starbucks. She alleged that through its exclusive leases, Starbucks bans...
-
The firms most recent financial statements were provided to its bank as support for the firms loan request. Joanne Peebie, a loan analyst trainee for the Morristown Bank and Trust, has been assigned...
-
What other criticisms do you think may be made against the classical universal approach to the design of organisational structure?
-
Mary Beth is a CPA, devoting 3,000 hours per year to her practice. She also owns an office building in which she rents out space to tenants. She devotes none of her time to the management of the...
-
List the eight wastes according to lean philosophy.
-
Of what value is this general grouping of national cultures to managers in their SIHRM activities?
-
How would you summarise the key differences between the classical universal, contingency and consistency approaches to the design of organisational structure?
-
48) When Scrum Team members meet and collaborate with each other to find the best way to build and deliver the software to the customer, which of the following Agile Values is being practiced?...
-
Juanita owns a home in Richardson, TX. She purchases a Homeowners Policy (HO-3) from Farm State Ins. Co. The policy provides $100,000 in liability coverage (coverage E) and $5,000 in Med Pay coverage...
-
Why is it important to keep a history of test cases and the results of those test cases even after a system has been revised several times?
-
List and describe the general sections of a typical business form. Do computer-based and paper based forms have the same components? Why or why not?
-
The owners of Timberline Technology (described in Problem and Exercise 4-35) are considering adding a plant in Montana and one in Arizona and six more sales representatives at various sites across...
-
An amorphous material is: (a) Mica (b) Lead (c) Rubber (d) Glass
-
Discuss the application vernier caliper and its method of measurement.
-
In center lathe, cutting tool is fed in ____ directions with reference to the lathe axis.
Study smarter with the SolutionInn App