So I need help doing parts d - h transaction processing DBMSs. Topics we cover will include:Relational Model ConceptsRelational Data Model ConstraintsPost-class assignment. Due dates are strictly enforced.1. Look back at the restaurant dataset from your last homework, You may have found that somerows didn't contain the same data as other rows, when they should have matched. Please tryto find a row and explain what's wrong.2. In your Module 2 homework, you divided the restaurant columns (attributes) into three parts:Restaurant, Inspection, Violation. In your HW 2, you tried to create an ERD from this. Pleasedraw the tables that come from the ERD entities (but not any relationships-that's the nextmodule)3.Look at your answer for (2). Please list all things that are present in your ERD from Module 2that are missing from your answer for (2).4.Please do Exercise 5.19 from your course textbook5.Please do Exercise 5.20 from your course textbook6. Define the following terms:a. Keyb.Superkeyc. Candidate Keyd.Primary KeyForeign Keye.f. Surrogate Keyg. Entity Integrity Constrainth. Referential Integrity ConstraintPlease hand in: Your submission must be a single Word (.docx) or PDF file.

As per Bartleby's rules, we can answer only 3 questions at a time, so I am answering 6) d, e and f I…

Answered: d. Primary Key e. Foreign Key f.…

Engineering

Computer Science

d. Primary Key e. Foreign Key f. Surrogate Key

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter2: Database Design Fundamentals

Section: Chapter Questions

Problem 5TD

See similar textbooks

Related questions

Q: What precisely are homonyms and synonyms in the context of database development, and why should you…

A: What precisely are homonyms and synonyms in the context of database development, and why should you…

Q: Why is it intrinsically more challenging to construct successful anomaly-based intrusion detection…

A: Introduction: intrusion detection system: An intrusion detection system is a piece of hardware or…

Q: Using Ford-Fulkerson's Method. Calculate the capacity in megalitres/hour of this pipe system.

A: Using Ford-Fulkerson's Method.

Q: Arrays are a data structure that you can use to store data. In your own words, describe the benefits…

A: Please find the answer in below step.

Q: The Cloud Computing Movement: Did It Have an Impact on Collaboration?

A: The term "cloud computing" refers to the on-demand: Access to computing resources such as…

Q: What distinguishes a dynamic stack from one that is static?

A: Static Stack: A static stack, also known as compile-time memory allocation, is used to allocate…

Q: Activity 2 Create a class named IbArrayActTwo_ with given elements (see below). The java program…

A: The JAVA code is given below with code and output screenshot Happy Coding ?

Q: Suppose we have two implementations of the same instruction set architecture. Computer A has a clock…

A: CPI Stands for Cycles Per Instruction .

Q: Discuss the standard that breaks up messages and data into packets to be routed over a network.

A: In this question we need to explain the standard which is responsible for data or message…

Q: What standards should a company employ to evaluate cloud computing?

A: Cloud computing is the delivery of different services through the Internet including data storage,…

Q: C# using Dapper DB Multimapping Step 1 is done already you must proceed to step 2 See attached…

A: In C# there is the mechanism called the Dapper. Dapper which it is an object relational mapping…

Q: What advantages do operating systems that don't depend on a certain piece of hardware offer?

A: 1. User Friendly The interface provided by the GUI is much more user friendly compared to a command…

Q: VLIW versus superscalar: whichever implementation presents more of a challenge for compilers? Which…

A: The more significant issue for compilers is either VLIW or superscalar. Since VLIW processors only…

Q: Database logs may be used to identify between two separate services. Are they meant to speak for…

A: The answer is given in the below step

Q: Why has virtual private network (VPN) technology taken over as the industry norm for tying remote…

A: VPN Technology: An encrypted connection between a device and a network via the Internet is known as…

Q: Describe the purpose of read-only memory (ROM) in the construction of a computer system. How much…

A: Given: Read-only memory (ROM) is a kind of non-volatile memory used to store data in computers and…

Q: Why is paperwork so important to a successful criminal investigation? List the bare minimum…

A: The response is provided down below: The Importance of Keeping Detailed Records of All Steps Taken…

Q: Prove that when using a dynamic array that grows and shrinks as in the previous exercise, the…

A: A dynamic array (Vector in C++, ArrayList in Java) will automatically grow when we try to insert and…

Q: Why is paperwork so important to a successful criminal investigation? List the bare minimum…

A: Any communicable material that is used to describe, explain, and/or instruct about some attributes…

Q: Ramifications for single eliminations for team (6,7,8,10). Compute the games and byes then show the…

A: Let G be Games Let W be winner Numbers - # of Teams For 6-Teams N= # of entries N-1 = # of…

Q: Why don't we use magnetic tape to store our data?

A: Magnetic tape to store our data: A media for sequential storage used for data gathering, backup, and…

Q: 3. Explain the role of device controller. How is device controller managing the process of…

A: Device Controller play an important role in order to operate that device.

Q: Find out how FIVE information systems/information technology have an effect on print and online…

A: BasicsAn information system is known as the study or use of frameworks, primarily personal computers…

Q: What is Impact of Web Technology in Ethics.

A: The answer to the question is given below:

Q: Using the instance of the Airport database, formulate the following queries in the relational…

A: Your query is given below as you required.

Q: How to Enhanced Security Services for S/MIME?

A: S/MIME: The security enhancmenet standard that used to protect the electronic mails, which is in…

Q: How to convert money to token by using tether crypto?

A: In this question we need to explain how users can convert their money to token (crypto) using the…

Q: Java Program: It is given to the same members containing n whole numbers. You have to switch to…

A: Below is the Java program for the given problem.

Q: Install Linux on a computer, then go through a rundown of some frequently used commands.

A: Given: The purpose of this demonstration is to go through the process of installing the Linux…

Q: Suppose we have two implementations of the same instruction set architecture. Computer A has a clock…

Q: Add code to the function named worldLoadAll that takes a World and a string as parameters. The…

A: Python is an object oriented programming language and the structured , general purpose programming…

Q: There is a contentious argument going on at the IT consulting company where you work. Some team…

A: Answer: Problems may first occur as a result of reluctance to change, but an analyst with good…

Q: Using the following key sequences draw the B are inserted one-by-one in the order given into

A: Solution - In the given question, we have to draw the B-tree of order 3 by inserting all the given…

Q: Discuss the following: A. Compare and contrast “World Wide Web” and the “Internet”. B. Discuss…

A: The answers is given below :

Q: In this part, discuss the key features of the Go-Bank-N and the Selective Repeat algorithms.

A: Introduction: Both the Go-Back-N protocol and the Selective repeat protocol are examples of sliding…

Q: A method for doing live backups of physical hard drives is to set up a RAID array, albeit doing so…

A: The phrase "Redundant Array of Independent or Inexpensive Disks" is what "RAID," or Inexpensive…

Q: Conclusions about sampling theorem in Matlab

A: In this question we have to understand about the sampling theorem in MATLAB Let's understand

Q: My question need to provide screenshot

A: The program is written in Java. Check the program screenshot for the correct indentation. Please…

Q: Programs that use virtual memory have both benefits and drawbacks.

A: 1) Virtual Memory is a storage mechanism which offers user an illusion of having a very big main…

Q: Examine your PC/Cell Phone. Using a four-column table format identify and record the following…

A: Almost all of us use various softwares in our day to day lives.

Q: List at least three characteristics of clouds according to the National Institute of Standards and…

A: National Institute of Standards and Technology has defined various characteristics for cloud…

Q: Differentiate between the transformed value propositions archetype and transformation via new value…

A: When it comes to new value propositions, digital transformation requires companies to rethink their…

Q: What is the aim of this page? Printing a whole book on a fast, non-impact printer takes around a…

A: Introduction: Fast printers that don't use impact paper may print the whole book in under a minute.…

Q: Draw the truth table of full adder.

A: In a full adder design we can actually create a carry input in the circuit and we could add it with…

Q: Why is secondary storage not built on semiconductor memory in the same manner as main storage is…

A: Semiconductor memory is a digital electronic semiconductor device used for digital data storage such…

Q: Consider globalization as a flexible organizational strategy that Amazon may use.

A: Definition: Amazon and similar e-commerce websites are just distributors and shopping portals; they…

Q: Give one instance of each of the following in the language of your choice: orthogonality,…

A: The answer to the question is given below:

Q: (A + B)(C + B)(D′ + B)(ACD′ + E) to SOP FORM

A: (A + B)(C + B)(D′ + B)(ACD′ + E) to SOP FORM Solution: A + B + E = A + B + C + D′ + E = (A +…

Q: Consider computational thinking and make a list of the key processes involved.

A: computation-based reasoning A collection of problem-solving techniques called computational thinking…

Q: How do posts in information security become filled at the National Security Agency (NSA)? To read…

A: positions for the NSA in information security The National Security Agency, or NSA, was established…

Concept explainers

Procedures in SQL

A pre-compiled stored procedure is a logical unit made up of one/more SQL statements (SQL stands for Structured Query Language). The database server saves it as an object. An SQL procedure is a collection of SQL statements and logic that is written and saved to accomplish a specified goal. An SQL procedure consists of a name, a parameter list, and a set of Transact-SQL statements. Stored procedures are stored as named objects in SQL Database Server.

Question

So I need help doing parts d - h

transaction processing DBMSs. Topics we cover will include:
Relational Model Concepts
Relational Data Model Constraints
Post-class assignment. Due dates are strictly enforced.
1. Look back at the restaurant dataset from your last homework, You may have found that some
rows didn't contain the same data as other rows, when they should have matched. Please try
to find a row and explain what's wrong.
2. In your Module 2 homework, you divided the restaurant columns (attributes) into three parts:
Restaurant, Inspection, Violation. In your HW 2, you tried to create an ERD from this. Please
draw the tables that come from the ERD entities (but not any relationships-that's the next
module)
3.
Look at your answer for (2). Please list all things that are present in your ERD from Module 2
that are missing from your answer for (2).
4.
Please do Exercise 5.19 from your course textbook
5.
Please do Exercise 5.20 from your course textbook
6. Define the following terms:
a. Key
b.
Superkey
c. Candidate Key
d.
Primary Key
Foreign Key
e.
f. Surrogate Key
g. Entity Integrity Constraint
h. Referential Integrity Constraint
Please hand in: Your submission must be a single Word (.docx) or PDF file.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

10. Sometimes logic for a query can be quite complex. It is possible to produce the desired outcomes through the use of subqueries, inline views, and UNION-type statements. For those methods, the transitional results are not saved in the database but are directly used within the query. This can lead to achievement issues, particularly when the transitional results have a huge number of Explain. a. columns b. rows c. reports d. databases
Create ERD for Real-estate database: There are Many Cities in each State There are Many Zip Codes in each City Many Houses belong to each ZipCode Each House can be one of HouseTypes ( Town House, Residential, Condo, Single Family) Each House can be Sold multiple times. ( entity Sales
Task 1: The InstantRide Management team founded a new team for car maintenance. The new team is responsible for the small maintenance operations for the cars in the InstantRide system. The main idea is to take actions faster and minimize the time spent for the maintenance. Therefore, the Car Maintenance team wants to store MAINTENACE_TYPE_ID (char(5)) and a MAINTENANCE_TYPE_DESCRIPTION (varchar(30)) in the database. Using MAINTENANCE_TYPE_ID as the PRIMARY KEY, create a new table, MAINTENANCE_TYPES, and send the table description with the column names and types to the Car Maintenance team. Task 2: The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENACNE_TYPE_ID should be foreign…
Task 1: The InstantRide Management team founded a new team for car maintenance. The new team is responsible for the small maintenance operations for the cars in the InstantRide system. The main idea is to take actions faster and minimize the time spent for the maintenance. Therefore, the Car Maintenance team wants to store MAINTENACE_TYPE_ID (char(5)) and a MAINTENANCE_TYPE_DESCRIPTION (varchar(30)) in the database. Using MAINTENANCE_TYPE_ID as the PRIMARY KEY, create a new table, MAINTENANCE_TYPES, and send the table description with the column names and types to the Car Maintenance team.
Task 1:The InstantRide Management team founded a new team for car maintenance. The new team is responsible for the small maintenance operations for the cars in the InstantRide system. The main idea is to take actions faster and minimize the time spent for the maintenance. Therefore, the Car Maintenance team wants to store MAINTENACE_TYPE_ID (char(5)) and a MAINTENANCE_TYPE_DESCRIPTION (varchar(30)) in the database. Using MAINTENANCE_TYPE_ID as the PRIMARY KEY, create a new table, MAINTENANCE_TYPES, and send the table description with the column names and types to the Car Maintenance team. THIS IS FOR CENGAGE MYSQL
A DreamHome database has following tables. Branch (branchNo, street, city, postcode) Staff (staffNo, fName, lName, position, sex, DOB, salary, branchNo) PropertyForRent (propertyNo, street, city, postcode, type, rooms, rent, ownerNo, staffNo, branchNo) PrivateOwner (ownerNo, fName, lName, address, telNo) How many rows and columns are there in the relation Branch X Staff, if Branch has 20 tuples and Staff has 15 tuples. ( ) 35 rows and 300 columns ( ) 300 rows and 35 columns ( ) 300 rows and 12 columns ( ) 35 rows and 12 columns
Task 6: The StayWell Property Management team considers creating a discount scheme for the property owners with more than one property in the system. You will need to provide all the owner IDs (OWNER_NUM) and the count of properties of the owners with more than one active property in the database. The output columns should be OWNER_NUM and COUNT(*) respectively.
Attributes, rows, and tables all refer to the same thing in relational models:
Answer the following prompts 1The InstantRide Management team founded a new team for car maintenance. The new team is responsible for the small maintenance operations for the cars in the InstantRide system. The main idea is to take actions faster and minimize the time spent for the maintenance. Therefore, the Car Maintenance team wants to store MAINTENANCE_TYPE_ID (char(5)) and a MAINTENANCE_TYPE_DESCRIPTION (varchar(30)) in the database. Using MAINTENANCE_TYPE_ID as the PRIMARY KEY, create a new table, MAINTENANCE_TYPES, and send the table description with the column names and types to the Car Maintenance team. 2The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENANCE_TYPE_ID…
What precisely is metadata? An answer to this question may be found in the result set's metadata. Result set information may be beneficial in a variety of situations.
Problem Statement: You are the CTO of a startup based out of Arlington, VA that needs to setup a database to keep track of the details of the customers: last name, first name, customer ID, street address, customer star rating (a rating on a 1– 5 scale, with 5 being best, representing the type of customer) and phone number. It also needs to keep track ofsimilar information for suppliers as well (although instead of supplier first and last name, there will just be a suppliercompany name). The database should maintain the data on products that are offered. Information about whichproduct is offered by which supplier should also be maintained. Finally, which customers have purchased whichproducts should also be tracked (note that we are only interested in which customers bought which product, but notconcerned about the date or how many were bought). 1.1 Business Rules: Assumptions for the business model are as follows:•Only customers that have purchased one or more products will exist in…
using php We run a dog grooming shop, there are new 4 breeds that are being registered to our system. Please add their names, breeds, and ages to the database, also display the new inputs with non-prepared statements Requirement 1: Require the programmer to insert rows Requirement 2: Require the programmer to display the rows after they have been changed Requirement 3: Require use of a non-prepared statement