Consider the following scenario and draw an E-R diagram for Mozar. Mozar has decided to store information about musicians who perform on its albums (as well as other company data) in a database. Each album that is recorded on the Mozar label has a title, a copyright date, a format (e.g., CD or MC), and an album identifier. Each album has a number of songs on it, but no song may appear on more than one album.Each album has exactly one musician who acts as its producer. A musician may produce several albums, of course. Each musician that records at Mozar has a SerialNo, a name, an address, and a phone number. Each address is made up of a street, a city and a postcode. Each musician may play several instruments, and a given instrument may be played by several musicians. Each instrument that is used in songs recorded at Mozar has an instrumentID, name (e.g., guitar, piano, flute) and a musical key (e.g., C, B-flat, E-flat). Each song is performed by one or more musicians, and a musician may perform a number of songs. Each song recorded at Mozar has a title and an author.

Draw ER (or EER) diagram: A conceptual database design for a chain of furniture stores is needed. The following is a summary of the database requirements: a) The chain has many different stores in various cities and states. Each STORE has unique StoreNumber, plus an Address(made up of Street, City, State, ZipCode), and a StoreManager (who is an employee). Each store is organized into a number of departments. b) Each DEPARTMENT contains certain types of furniture (such as ‘dining’, ‘living room’, ‘bedroom’, ‘office’, etc.), and has a DeptName that is unique within each store; it also has a DeptManager (who is an employee), and a number of SalesPersons (who are employees). c) The company employs many employees. Each EMPLOYEE has a unique SSN, plus a Name (made up of FirstName, Minit, LastName), a job (e.g. ‘store manager’, ‘dept manager’, ‘sales associate’, ‘sales person’, etc.), plus DateOfBirth, Sex, Salary, and CommissionRate. Each employee works for a particular store. Design an ER…

Draw the relationships and entities model for each of the following: * in the traditional way* for example: see the pic??.   In the database of the library, the author can author more than one book, and the book can be subscribed toWritten by more than one author

You are given the requirement for a simple database for the national football league(NFL). The NFL has many teams, and each team has a name, a city, a coach, a captain and a set of players. Each players belong to only one team and each player has a name, a position (such as left wing, mid fielder or a goal keeper) , a skill level, and a set of injury records. A team captain is also a player who guide other player and a game is played between two teams(referred as host team and guest team) and has a match date( such as june 11, 2018) and score (such as 2 to 5)  Your design should include an E-R diagram, a set of relational schemas, and a list of constraints, including primary-key and foreign-key constraints.

Let's say there is only room for one student in a course, and two people are seeking to sign up. What property of a database system makes it impossible for both students to be placed in the last open seat?

Although you always wanted to be a dog trainer, you ended up being an expert on databases because you love to work with data and logic. Your old love is still there, however, so you set up a database company, DogTraining, that builds a product for dog kennels. The core of this product is a database with a schema that captures all the information that kennels need to maintain. Kennels keep information about dog trainers, the First and Last names of the dog trainers (which are unique), birthplace, color of the dog trainers hair, and style of training.  For each dog, the trainer, the date the dog was born, a name (not unique), the type of dog (e.g., Brittany, German Shepard, Collie, etc.), color of the dog’s hair, and how much weighs must be stored. Dogs are also classified into groups of various kinds, for example, hunting, guard, working; a given dog may belong to more than one group. Each group is identified by a name (like those just given) that describes the group. Finally, kennels…

"Pictures are saved in a database, and the design/structure we've chosen includes some highly sensitive information about the drivers," explains the head of your section. "Wouldn't it be better if we put it in a separate file so only those who need it can access it?" If you had to choose a position, which approach would you use? Justify your assertions.

Draw a clear and complete ER diagram

The scenario is for a small life insurance agency and their need to keep track of clients, agents, insurers, and quotations. 1) A Client is a customer, potential customer, or contact of the agency. We need to assign each client a number and save their last name, first name, birth date, gender, telephone number, email address, and the agent who brought the client into the agency. If a client is a “walk in” they are assigned to the first available agent. All clients must have one primary agent. 2) An agent is a licensed individual with the state. Each agent has a nationally unique license number, last name, first name, telephone number, and email address. An agent must be the primary agent for at least one client but may not be primary for more than 500 clients. An agent must also be part of at least one quotation and may share in an unlimited number of quotes. 3) The agency represents (does business with) many insurance companies (insurers). We will need to track each insurer with an…

Draw an ERD containing the Transaction and Item entities. When a transaction is made, the date (TransDate) and type (TransType) together with TransNo (primary key) must be recorded. For an item, add attributes of ItemNo (primary key), ItemType, and RawCost. A transaction may include multiple items and an item may be included in multiple transactions. When an item is included in a transaction, Quantity and TransPrice of the item must be recorded.