Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I was not given an ER diagram to do these questions. this is the only information I have. Question 5 0/2 points Your professor is
I was not given an ER diagram to do these questions. this is the only information I have.
Question 5 0/2 points Your professor is advising a new crowd-funding app for women's self-help groups (SHGs) in Latin America on their database architecture. This is the business requirement she has worked on: All campaigns belong to a SHG. An SHG must exist before a campaign is created, and when an SHG is deleted from the database, all its campaigns are deleted. SHGs always belong to a country, and a country must be added to the app before SHGs are added to it. Which of the following is true of the entities defined in the database? Select all that apply. An SHG entity depends on a Campaign entity. An SHG is a Master entity for a Campaign. A Campaign entity is a Master entity for an SHG. A Country is an Independent entity. An SHG entity is dependent on a Country entity. A Campaign is an Independent entity. Hide Feedback According to the business requirements, an SHG must be created before a campaign can be created, which makes an SHG a Master entity for a Campaign. In addition, an SHG cannot be created unless a Country is already present; this means an SHG entity is dependent on a Country entity. Finally, it's clear from the requirements that a Country exists independent of any other entity. Question 6 0/2 points Your nephew, who is a junior in high school, has been asked to work on a database for NBA teams. The following are the requirements he has been given: All teams play in the Eastern Conference or the Western Conference. Teams in each conference are named for cities or states. Some teams have moved from one conference to another. He asks for help in defining entities and attributes. Which of the following would you advise? Select all that apply. NBA as supertype with Conference as subtype Conference as subtype under Team as supertype Team as subtype under Conference as supertype City and State as subtypes under Team as supertype TeamMoved as attribute of Conference subtype CityName as attribute of Team supertype Hide Feedback A Team is a supertype entity because it is the basic unit of the NBA. A Conference is a subtype entity of the Team entity because a Conference consists of a subset of all teams in the NBA. Teams named for a City or State are other subsets of all teams. so City and State are subtype entities under Team as supertype. A Team may be named for a City, so City Name is an attribute of the supertype entity Team. A Team may have moved from one Conference to the other, so TeamMoved is an attribute of the Conference subtype entity. Question 10 0/2 points The following ParticipantGrade table contains four columns named FirstName, LastName, StudentiD, and Grade. StudentID is the only auto-increment field in the table and Grade is a NOT NULL field that can only accept one letter value between A and F. Values for three records are provided below. FirstName LastName StudentID Grade Jean Altman 3018 Tyler Swift 3019 Dave Capell 3020 INSERT statements to add more students are given below. Which of these will result in errors? Select all that apply. INSERT INTO ParticipantGrade VALUES ('Nora', Jones 3021. A); INSERT INTO ParticipantGrade VALUES ('Jones' 'Nora."); INSERT INTO Participant VALUES (Jones', 'Nora..); INSERT INTO ParticipantGrade VALUES ('Norah Jones'.A'); Hide Feedback Inserting primary key values for auto-increment columns such as the StudentID will result an error; in one of the syntax options, new Studentin was entered as 3021 although it would have been auto-incremented. Another error that database users make is entering Null values for columns that are NOT NULL, such as the Grade column; in one of the syntax options, no value was provided for Grade, which is a NOT NULL column. A third type of error is omitting the column names but entering values in the Values clause in an order that doesn't match the order of the column names. This is seen in another syntax option that enters LastName before FirstNameStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started