22 Which binary relationship occurs if a student takes one of three available sections of a Database Management course and is also enrolled in a Principles of Management Accounting course? O One-to-One O Many-to-Many Associative One-to-Many

1. Create a database diagram that shows the relationships between the seven tables in the MyGuitarShop database. (The administrators table is not related to the other six tables.)2. Design a database diagram for a database that stores information about the downloads that users make from a website.Each user must have an email address, first name, and last name.Each user can have one or more downloads.Each download must have a filename and download date/time.Each product can be related to one or more downloads.Each product must have a name.

Exercise 1-2 A small library keeps a roster of who will be at the desk each day. They have a database table as shown in Figure 1-8. week_start - Mon - Tue - wed - Thur - Fri 17/10/2011 Jane 24/10/2011 Jane Sue George Sue Jane Sue Linda Sue Lee 31/10/2011 Sue Sue Lee George George Figure 1-8. An initial database table to record roster duties What problems can you foresee in making good use of this information? Suggest some better ways that this information could be stored.

Map the database schema shown in the following figure into a relational database schema. grade semester section# room schedule cid title --- M enrolled in Class instance of Course N N M sid M evaluation name Student taught by can teach offered by M gender 1 N advised by Instructor belons to Department instid name rank dname 000

I need the answer as soon as possible

Relationships in a database might be either identifying or non-identifying or generic.

Which of the following is a key part of physical design in an entity relationship model? O This model converts attributes into columns. O This model does not depend on the database management software or the hardware used to implement the model. O This model avoids any database model-specific details. This model resolves the many-to-many relationships to multiple one-to- many relationships.

Wally Los Gatos decides to pursue a law degree. After graduating, he has teamed up with Lyla El Pajaroto form Peck and Paw, Attorneys at Law. Wally and Lyla have hired you to design a database systembased upon the following set of business rules. It is in your best interest to perform a thorough analysis, toavoid needless litigation. Please create an ER model based up on the following set of rules:• an attorney is retained by one or more clients, for each case• attributes of attorney are: attorneyID, name (firstName, lastName), address (street, city, state,zipcode), specialty (may be more than one), bar (may be more than one)• a client may have only one attorney for each case• attributes of client are name (firstName, lastName), address, city, state, zipcode, telephone,dateOfBirth• a client may have more than one case• attributes of case are caseID, case_description, caseType• an attorney may have more than one case• each case is assigned to one and only one court• attributes of court…

Question 5   Full explain this question and text typing work only thanks

Database System In database management, which of the following is a design case that occurs only when there is an improper relationship or represented in a non-consistent way? Choose an answer A Implementing Relationships B Redundant Relationships C Fan Traps D Maintaining time variant data