Consider the LIBRARY relational database schema description provided below which is used to keep track of books, borrowers, and book loans. The relations are: • BOOK (BookID, Title, PublisherName) • BOOK_AUTHORS (BookID, AuthorName) • PUBLISHER (Name, Address, Phone) • BOOK_COPIES (BookID, BranchID, NumberOfCopies) • BOOK_LOANS (BookID, BranchID, CardNumber, DateOut, DueDate) • LIBRARY_BRANCH (BranchID, BranchName, Address) • BORROWER (CardNumber, Name, Address, Phone) 1. Consider the schema given above: (a) (5 points) Give a primary key for each relation. Are there any relations for which there is an alternate candidate key that you have not chosen as the primary key? If yes, mention the relations, candidate keys and the reason (if any) for your choice of the primary key. (b) (10 points) State all referential integrity constraints that should hold on these relations.

Answers

Answer 1

Answer:

1) Yes, Publisher relation should have a publisherID primary key.

2) NOT NULL and UNIQUE for the BookID, BranchID, CardNumber and name of the borrower in the Book, Book_Copies, Library_branch, and Borrower relations respectively. The DueDate field of the book_loan relation must be a time constraint. The BookID of the Book relation must be serial number for automatic addition and update of bookid across the database.

Explanation:

The Publisher relation should have primary key publisherID which should replace the publisherName in the Book relation to easily make a join query and attain a third-level database model.


Related Questions

this is used to copy information from cell to cell in the spread sheet

A. active cell
B. Auto fit
C. Grid lines
D. Fill handle

please help me with this

Answers

Answer:

D. Fill handle

Explanation:

Required

Which can be used to copy from cell to cell

(a); Means the current cell being selected in the spreadsheet program

(b): Used to fit all columns in the spreadsheet program. Usually, the columns are fitted based on their width.

(c): The vertical and horizontal lines that separate cells.

(d): This is used to copy from one cell to another, especially adjacent cells.

Select the correct answer from each drop-down menu.
How does a function work?

A function takes values in the form of____, performs a calculation, and returns a ____.

First blank:
1. Keywords
2. Arguments
3. Math operators

Second blank:
1. Result
2. Cell reference
3. Formula

Answers

Answer:

Maths operators

cell reference

Answer:

Arguments

Result

Explanation:

I got it right on the Edmentum test.

I will give free brainiest if you guess my favorite car among these 3

Corvette
LaFerrari
Porsche

Answers

Answer:

LaFerrari

Explanation:

Determining which computer platform (operating system) would be best for a particular student often depends on what the student wants to study and in which industry she or he wants to enter after graduation. Students who plan to study graphic design or want to focus on photo production or publishing should strongly consider the __ platform since it is generally considered the industry standard in those fields.

Answers

Answer: Window OS

Explanation:

Based on the information given, it should be noted that the students who plan to study graphic design should consider the Window OS platform since it is considered to be the industry standard in those fields.

Microsoft Windows, also refered to as the Windows OS, is a computer operating system that's developed by Microsoft to run personal computers. It has the first graphical user interface and also, the Windows OS dominates the personal computer market.

"NOTE: write an algorithm, not a code" You are given a file called "std" and composed of "Number, Name, Address" fields. (You can define the type of fields by yourself) Write an algorithm that makes "insert, delete, update and retrieve", processes on the records in the file. "Number" field is the key of each record. Here is the template of report: Steps Actions 1 Name of the report and date 2 Author of report 3. Literature review 4. Your contribution 5 Explanation algorithm and sub algorithms 6 Summary 7. Future advice 8. References

Answers

Answer:

1. get the absolute path to the file

2. load the file as a table (dataframe in python)

3. to insert a row;

create a dataframe of the same field typeconcatenate the new dataframe horizontally with the same dataframe

4. to delete a row, select and drop the row where the 'Number' field matches a value.

5. to update the values in row, use the number field as a key to replace the existing values.

6. print of save to a variable the rows where the number field matches a given value.

Explanation:

Follow the report template to create a report for the algorithm.

The algorithm gets the absolute path to the file and loads the file as a tabular file from there the data can be queried without accessing the main file. The insert algorithm creates a new dataframe and appends it to the main dataframe.

The delete, update and retrieve all use the same subalgorithm, getting the rows with the number field as the key value.

You suspect that your web server has been the target of a denial-of-service attack. You would like to view information about the number of connections to the server over the past three days. Which log would you most likely examine

Answers

Answer:

Performance log

Explanation:

The Windows Performance Logs and Alerts, is a service that monitors and collects the performance data on resources, processes, threads, cache, memory, and processor, dependent on parameters which are preconfigured and scheduled, and logs the data or results in an alert

The service can be enabled from the file perfmon.exe

From the logs, troubleshooting the security of the system can be performed by monitoring file access, unusual or unauthorized activities, network connections, unusual system behavior, error messages and unusual network behavior

My pc is not reproducing sound

Answers

Answer:

check your settings try to seek your audio settingfix it

A swimmer covers 180m in 20 seconds. How many metres does she swim in one second?​

Answers

Answer:

9 meters per second

Explanation:

180/20= 9

An online news website relies on in-page advertisements to make money. Their article pages have multiple slots for advertisements, and each slot can be used for a full-size ad or multiple smaller ads. Advertisers specify their size and desired display count per day. A diagram of a webpage. Article text is shown alongside multiple advertising boxes on the page. The news site uses a scheduling algorithm to determine which advertisements to display in each slot at each time of day. The algorithm's goal is to maximize money earned while not exceeding the display count per day, so it tries out every possible combination and picks the best one. As the number of advertisers and articles increases, the news site realizes the scheduling algorithm is taking an unreasonable amount of time and costing them valuable server time. What is the most promising way that they can improve the run time of the algorithm

Answers

Answer:

Create a dynamic-sized circularly-linked list to hold a tuple of the adverts and the count. As the program runs, the sum of the counts is used to calculate the fixed advertisement time which is saved in a variable time_slot. Then a loop statement should be used to traversal the linked list continuously until the count sum is exhausted for the day.

Explanation:

A circularly-linked list is a linked list with both ends joined together. With this data structure, the continuous traversal of the list is easier and faster. A conditional statement is used in the algorithm to check and decrement the count of each advert and when all is zero or false, the program ends.

please answer this question​

Answers

Explanation:

A. Encryption. (B. Printer

How can you make a search phrase more effective?
O A. by framing it as a question
O B. by using more specific search terms
C. by using a different search engine
OD. by using all the search terms you can think of

Answers

Let's solve this together.

To make a search term more accurate, you must keep it simple and you must be able to use more specific terms. The more specific you are with what you are asking the engine about, the more friendlier it will respond.

The answer is Option B. I hope this answer helped you!

Identify the tips to create a well-designed digital portfolio.
Felicity consulted her professor at her university for help in creating a digital portfolio. Her professor told her about the importance of creating a well-designed digital portfolio. She finally began work on the same.

A. She accessed a computer to build a digital portfolio.
B. She created a personal website with a unique URL for her online portfolio.
C. She took out the text that described her images from her portfolio.
D. She accessed a printer with could print high resolution images.

Answers

Answer:

B. She created a person website with a unique URL for her online portfolio

Explanation:

What is one similarity between compiled and interpreted programming languages? (5 points)

Both compiled and interpreted languages are translated one line of code at a time before moving to the next line.

Both compiled and interpreted languages can be shared with others while keeping the source code private.

Both compiled and interpreted languages are high-level languages and translate code for a computer to understand.

There are no similarities between compiled and interpreted programming languages.

Answers

Answer:

Both compiled and interpreted languages are high-level languages and translate code for a computer to understand.

Explanation:

The one similarity between compiled and interpreted languages is that they are both high-level languages.

A high-level language is a computer language written in easy to understand human language which is then converted to machine code for the computer to understand.  

A high-level language can either be interpreted or compiled.

An interpreted is a language in which the code is translated line by line before execution while a compiled language is one in which the source code is converted directly into machine language before execution.

So, the similarity between both languages is that they are high level languages and translate code for a computer to understand.

Select the correct answer from each drop-down menu.
Complete the sentence about emphasizing data in a worksheet.

Formatting a cell can refer to _____ formatting and to ____ formatting.

First blank:
1. Unhiding
2. Inserting formulas in
3. Highlighting

Second blank:
1. Changing the font size in the cells that contain the data
2. Moving the data to a separate row or column
3. Creating a header for the row in which the data appears

Answers

Answer:

Highlighting

Changing the font size in the cells that contain the data

Explanation:

I got it right on the Edmentum test.

The complete sentence about emphasizing data in a worksheet is given below:

Formatting a cell can refer to highlighting formatting and to changing the font size in the cells that contain the data formatting.

Thus, the correct options for blanks are C and A respectively.

What is data formatting?

Data formatting may be defined as the process of organization of information according to preset specifications usually for computer processing in order to execute with respect to the instructions.

The concept of data processing deals with the sequential arrangement of sources and information on the basis of certain specifications. The formatting of a specific cell refers to highlighting them for easy identification.

The process of formatting must be done in order to alter the size of the font within the cells that significantly contain the data.

Therefore, the correct options for blanks are C and A respectively.

To learn more about Data formatting, refer to the link:

https://brainly.com/question/25051360

#SPJ2

Lots of data can be transferred in short time, when we have,
a.High latency
b.Higher bandwidth
c.Lagging
d. Lower bandwidth

Answers

Answer: B. Higher Bandwidth

Thank you lord lord please thank you

Arrange the code so that the numbers are swapped.

Second part

savec

First part

C=D

Third part

D= save

Answers

Answer:

Following are the correct code for swapping:

save=C

C=D

D=save

Explanation:

Please find the attached file of the program with output.

In the above, we let that the three integer variable "save, C, and D" is declared that in which the variable "C and D" holds a value and "save" variable is used to hold "C" variable value.

At this the "C" variable is empty. so, it holds a "D" variable value and when it is empty it holds a save value. At this, we perform the swapping.

I got a question in computer science I don't understand, can someone please help.​

Answers

Answer:

Hi, this program allows you to calculate a sphere’s area and volume depending on the radius of your choosing.

Please give brainliest, means alot!

Select the correct answer.
Which formula below will return the same result as the formula =SUM(B1:B5)?

A.
=B1+B5
B.
=B1+B2+B3+B4+B5
C.
=B1,B2,B3,B4,B5
D.
=B1,B5
E.
=#B1:#B5

Answers

D because of the sun

Which Of these best describes what a binary digit can store?

Answers

Answer:

A

Explanation:

binary is in the root of 2 so it's only having values 1 and 0

You have an application that you would like to run on your Windows workstation every Monday at 3:00 p.m. Which tool would you use to configure the application to run automatically

Answers

Answer:

Task Scheduler

Explanation:

Task Scheduler allows you to automate tasks in Windows 10

What anime is sama from

Answers

Answer:

u talking about Kaichō wa Maid-sama? idek there is a lot

Explanation:

Rodney, a user in the research department, reports that he is experiencing blue screen errors while using his Windows computer. You ask Rodney if anything has changed on the computer recently. Rodney explains that he recently installed a TV tuner board in an expansion slot. Now he has to reboot the computer every time he loads the TV tuner application to watch TV. You need to fix Rodney's computer and prevent Rodney from using the TV until you can install an updated driver. What should you do?

Answers

Answer:

Remove the tuner board from the expansion slot. That way he can't use it to watch TV and you likely will eliminate the source of BSODs.

If you want to be sure that the tuner board is the cause of BSODs, check the stop code on the BSOD, or debug the minidump file that is auto generated by Windows whenever it crashes. Or, if you configure windows for a full memory dump, you can wait for another crash and then analyze the full dump instead.

why do we use number calculations in programming

Answers

Answer:

Standard arithmetic is used in many functions of programming. Addition, subtraction, multiplication and division are used in almost every program. Algebra is used to solve simple problems that many computer programmers will encounter

eg:

Obtaining a computer science degree requires completing many math classes

Choose the option that best matches the description given. The older term, social service, referred to advancing human welfare. The new term, meaning to provide for the needs of various people and groups, is ____.
A. social assistance
B.social welfare
C.social media
For everyone that doesn't wanna watch the ads, The answer is A, social assistance.

Answers

Answer:

Social Assistance

Explanation:

Provision and disbursement of intervention in other to palliate the suffering and want of an individual, group or community can be described as rendering social assistance. Assistance which also means helping people fulfill their needs could be offered by the government, non-governmental organizations or individuals personnels. Rendering social assistance could be in the form of cash or gift offerings, provision of food for the hungry, shelter for the homeless, medical interventions for the sick and catering for other touch points of the needy.

Answer:

Social Assistance

Explanation:

[Plato] In A Soccer Game, You Want To Finish The First Half In Five Minutes. So, You Set The Match Duration To Ten Minutes. This Is An Example Of What Kind
Of Time Element?

A)Altered
B)Variable
C)Authentic
D)Player Adjusted

Answers

Answer: D. Player Adjusted

Explanation: The reason why the answer is player adjusted is because a player in the game is changing the time to 10 minutes.

Have a nice day!

This Is for game design

Imagine you are the human resource director for a small video game company that employs around 20 coders, managers, artists, etc. You’re in charge of writing the safety rules and regulations for the company. Provide at least four discrete rules you would implement

Answers

1. Don’t give out any company information to someone who doesn’t work for the company.
2. Credit sources found from others games or anything that has a copyright claim.
3. Don’t abuse your power such as exploiting the games or hacking it to help yourself or friends.
4. Treat everyone with upmost respect

Match the elements used in web searches to their functions.

1. row
2. column
3. cell
4. worksheet

where data and formulas can be entered
a grid of rows and columns
a horizontal set of cells
a vertical set of cells

Answers

Row - horizontal
Column - vertical
Cell - where data and formulas can be entered
Worksheet - a grid of rows and columns

Answer:

where data and formulas can be entered - Cells

A grid of rows and columns - Worksheet

A horizontal set of cells - Row

A vertical set of cells - Column

Explanation:

I got it right on the Edmentum test.

Why making sustainable food choices is better for the environment and the disadvantages or negative effects when not choosing sustainable food products may have.

Answers

Answer:

Question 1:

I. It will help to reduce or eliminate wastes

II. It will help to conserve energy

III. It will help to improve the quality of life.

Question 2:

I. It will lead to environmental pollution

II. It will lead to poor quality of products

III. It will deplete the natural resources and energy.

Explanation: Sustainable food choices are the various choices and decisions we make when choosing the various processes and activities required to produce,process and consume food with the aim of ensuring that energy is conserved, pollution is reduced or eliminated, energy and the natural resources in and around the environment are effectively utilised to help improve the quality of life and environmental. There are several negative consequences of not adopting sustainable food products which includes pollution, energy depletion, poor quality of life etc.

defination of formula work sheet​

Answers

Explanation:

formula is an equation that makes calculations based on the data in your spreadsheet. Formulas are entered into a cell in your worksheet. They must begin with an equal sign, followed by the addresses of the cells that will be calculated upon, with an appropriate operand placed in between.

*****HELP******
Most Favored Nation (MFN) status and national treatment are also included in the Agreement on Trade-Related Aspects of Intellectual Property Rights (TRIPS). True or False

Answers

Answer:

True

Explanation:

The Most Favored Nation (MFN) status and national treatment are provided for in article 4 of the Trade Related Aspects of Intellectual Property Rights (TRIPS) Agreement and it is stated that when a member grants favor, advantage, immunity , or privilege to citizens of a country, the country shall grant similar favor, privileges and advantages to the citizens of the other members

Therefore;

True Most Favored Nation (MFN) status and national treatment are also included in the Agreement on Trade-Related Aspects of intellectual Property Rights (TRIPS).

Other Questions
Prior to 1848, monumental canvasses were reserved for _________________. a. religious images b. triptychs c. heroic subjects and pictures of the powerful d. landscapes can someone help me Does climate change cause global warming ? Describe how Alzheimers people get affected in Activities of daily living and How can be treated?use ur own words pls Determine the kinetic energy of 1000 kg roller coaster car that is moving with speed of 20.0m/s (KE=1/2mv)(PE=mgh (g=9.8m/s) 08.04 MC) An unknown solution has a pH of 7.2. Which of these chemicals is likely to cause the greatest decrease in the pH of the solution when added to the solution? (5 points) a HF b KOH c NH3 d HNO3 he conversion process where nitrogen gas combines with hydrogen to form ammonium ions, which is accomplished through the intense energy of lightening, or when air in the top layer of soil comes into contact with certain bacteria, is known as If 6.75 g of NaOH are dissolved in 50.00 g of water and the temperature increases from 20.5C to 47.8 C.a. Is this an example of an endothermic or exothermic reaction?b. What is the q for the reaction? (Remember since the NaOH dissolves in water add the masses to get the m)c. How many moles of NaOH are dissolved?d. What is the H for the reaction? Which inference can be best drawn about ray bradburys work from his commencement speech? When red light and green light are mixed, the color created is Nepal supplies cheap labor in International Labour market particularly in Gulf countries. what are your suggestions? (Help!) I need somebody (Help!) Not just anybody (Help!) You know I need someone (Help!). Algebra question :) reposicion los misterios (vocabulario y verbos en el preterito o imperfectio Please help ill make you the brainiest(please no link people) (2+3i)+(-4+i) left-parenthesis 2 plus 3 i right-parenthesis plus left-parenthesis negative 4 plus i right-parenthesis Cover letter to be an Electrician ( for a resume ) please help me out ill mark u brainlist Please help with the question below what is the positive impact of Commerce subject on our society? Help! Ill give brainliest if I can!