To store the PC model 1100 information in the database, we can use two INSERT statements. The first statement would insert the model information, such as manufacturer C, speed 3.2, RAM 1024, hard disk 180, and price $2499. The second statement would insert the laptop information, which includes the same manufacturer, speed, RAM, and hard disk, a 17-inch screen, model number 1100 greater, and price $500 more.
To delete all PCs with less than 100 gigabytes of hard disk, we can use the DELETE statement with a WHERE clause specifying the condition.
To delete all laptops made by a manufacturer that doesn't make printers, we can use a subquery in the DELETE statement to select all laptop models that have a manufacturer that doesn't appear in the printer manufacturer list.
To change all products made by manufacturer B to be made by manufacturer A after A buys B, we can use the UPDATE statement with a WHERE clause specifying the manufacturer as B and set the manufacturer to A.
In summary, these operations require the use of SQL statements, including INSERT, DELETE, and UPDATE, to manipulate data in the database.
Let's break it down step by step:
a) To insert the PC model 1100 with the specified details, you'll need two INSERT statements:
1. INSERT INTO PC (model, manufacturer, speed, ram, hard_disk, price) VALUES (1100, 'C', 3.2, 1024, 180, 2499);
b) To insert a laptop for every PC with the same specs, a 17-inch screen, a model number 1100 greater, and a price $500 more, you can use an INSERT statement with a SELECT statement:
2. INSERT INTO Laptop (model, manufacturer, speed, ram, hard_disk, screen, price)
SELECT model+1100, manufacturer, speed, ram, hard_disk, 17, price+500 FROM PC;
c) To delete all PCs with less than 100 gigabytes of hard disk, use a DELETE statement:
3. DELETE FROM PC WHERE hard_disk < 100;
d) To delete all laptops made by manufacturers that don't make printers, use a DELETE statement with a subquery:
4. DELETE FROM Laptop WHERE manufacturer NOT IN (SELECT DISTINCT manufacturer FROM Printer);
e) To change all products made by manufacturer B to be made by manufacturer A after manufacturer A buys manufacturer B, use UPDATE statements:
5. UPDATE PC SET manufacturer = 'A' WHERE manufacturer = 'B';
6. UPDATE Laptop SET manufacturer = 'A' WHERE manufacturer = 'B';
7. UPDATE Printer SET manufacturer = 'A' WHERE manufacturer = 'B';
Remember to replace the table and column names with the ones used in your specific database.
For more information on database visit:
brainly.com/question/30634903
#SPJ11
Write a loop that will take in 5 numbers from the user and output the average. Round your answer to two decimal places.
Sample Run:
Enter a number: 2
Enter a number: 7
Enter a number: 11
Enter a number: 4
Enter a number: 5
The average is 5.8
Hurry please!! will mark brainliest!!
Evaluate each condition as to whether it is true or not.
You can join the Army if you are over 17 and healthy. Have you met those requirements if you are 16 and healthy?
You can earn a scholarship if you have an ACT over 30 or you are valedictorian of your high school. Have you eamed a scholarship if you have an ACT
of 34 but are not the valedictorian?
Answer:
For the first one you have not met those requirements because you are still 16, for the second one you have met those requirements because you can either have a score over 30 (which you have 34) or be a valedictorian
Explanation:
Above
press _________ to toggle the selected range as bold
Answer:
press the b that i in a dark shade that is bold
Gui screen usually contain elements that are called?
Answer: Widgets
Components
Controls
Explanation:
3. Windows that are viewed as Web pages have
sections. **
Answer:
when the when the when the add the when are you is id god his gay for your top off jack dafe cafe read line green red whats the answer
Explanation:
What does this mean
Answer:
"Y YUR Y YUB I CUR YY 4 ME"
Explanation:
thats what i read lol, i dont know the meaning though
If you would like to give another user permissions on your mailbox or to particular folders within your mailbox, which role should you configure?
Assignee
Client
Delegate
Manager
Answer:
I think it's B, Delegate
Explanation:
Cause the other options didn't seem to fit as the answer.
I really don't know though.
A delegate is someone who has been granted permission by another user to access. The correct answer would be an option (C).
What is a mailbox?A computer-simulated mailbox that stores email messages. Mailboxes are saved on a disc as a message file or a message database.
A delegate is someone who has been granted permission by another user to access and manage their mailbox, including sending and responding to email messages on their behalf.
When you grant delegate access to another person, you are giving them the ability to access specific folders within your mailbox and perform specific actions, such as reading, sending, and deleting email messages.
Assignee, client, and manager are not terms typically used in the context of delegate access in email systems.
Thus, the correct answer would be option (C).
Learn more about the mailbox here:
https://brainly.com/question/28430685
#SPJ6
What is block palette
Help!!
What’s the inputs and outputs of a printer
And what’s the inputs and outputs of a digital assistant/ Alexa??
Answer:
Input of printer - text
Output of Printer - text printed on paper
Input & output of digital Alexa - Voice/sound
Explanation:
Input for a printer is the text data entered into any of the file formats that can be printed.
Output of a printer is the text printed on a piece of paper.
Input of a digital assistant is in the form of voice
Output of a digital assistant in the form of sound
In your own words, describe invention.
Answer:
An invention is an action of doing or creating something. Typically, a process of something.
Explanation:
Hopefully, it helps!
Answer:
Creating something new
Explanation: Invention is something that you originally create and don't copy from anyone else. The microwave was invented in 1945 that changed of how people used kitchen appliances, invention is kinda just another word for creativity (since it's the process of it!)
Hope this helps and make sure to thank me!
Explanation:
Question #6
Multiple Choice
What tag is used to contain information about a web page, such as the title and related pages?
O
O
Answer: b; head
Explanation:
Answer: <head>
Explanation: EDGE '23
What type of device is a keyboard?
Input
Memory
Output
Storage
Answer:
a keyboard is an input device
it's an input
Explanation:
There are three different types of peripherals: Input, used to interact with, or send data to the computer (mouse, keyboards, etc.) Output, which provides output to the user from the computer (monitors, printers, etc.) Storage, which stores data processed by the computer (hard drives, flash drives, etc.)
what will the following program display in the console
Write a definition in your own words for Raster Graphic. Do not copy and paste please.
Answer:
Raster Graphic is a bitmap. They are basically a grid of small pixels that make an image.
70s music or russian music
Explanation:
BB cgbfyhcthcfgvxdrgjyfddg
Create a file name that to ensure the that the file is easy to find
Answer:
I always name mine something like HI
or YEET i dont know
why but it works
Explanation:
What is Exploring technology?
Answer:
Investigating Technology is a thorough, activity based, course that acquaints understudies with innovation and its effect on society.
Explanation:
Answer: Exploring Technology is a comprehensive, action-based, course that introduces students to technology and its impact on society.
Explanation: it on googIe....
Multiple Select
Which of the following statements about localization are true? Select 2 options.
The goal of localization is to create an application or site that looks and feels like it was created for a specific market.
Really the only issue in localization is translating the text into another language.
You should avoid slang and idioms, since they will not be understandable to many audiences.
It is a good idea to use lots of images, since they are easily understood by all cultures.
For consistency, it is a good idea to use dollars as a currency in all versions of an application
Answer:
A. The goal of localization is to create an application or site that looks and feels like it was created for a specific market.
B. Really the only issue in localization is translating the text into another language.
Explanation:
In Computer science, localization can be defined as the process of designing, developing and adaptation of computer software applications or websites for different languages and geographical regions with peculiar differences.
This ultimately implies that, the main purpose for localization of a product such as a website or software application is to ensure they are specialized and specifically suited for a linguistic or geographical region.
The following statements about localization are true;
I. The goal of localization is to create an application or site that looks and feels like it was created for a specific market.
II. Really the only issue in localization is translating the text into another language.
Answer:
C. You should avoid slang and idioms since they will not be understandable to many audiences.
A. The goal of localization is to create an application or site that looks and feels like it was created for a specific market.
are the answers
Explanation:
What is the 3 common keys used to access the BIOS.
Answer:
To access your BIOS, you'll need to press a key during the boot-up process. This key is often displayed during the boot process with a message “Press F2 to access BIOS”, “Press <DEL> to enter setup”, or something similar. Common keys you may need to press include Delete, F1, F2, and Escape.
Accenture began its own Cloud journey in 2015, after our internal IT organization recognized the significant advantages to be gained in leveraging Cloud capabilities at scale. Today, which percentage of Accenture's infrastructure and processes are in the Cloud?
Answer: 95%
Explanation:
Accenture began its own Cloud journey in 2015, and invested in about $3 billion to move to cloud. This has helped the company in timely delivery and achieving organizational goals.
Today, the percentage of Accenture's infrastructure and processes that are in the Cloud is about 95%. Its HR, sales, finance, legal system etc are all in cloud.
The percentage of Accenture's infrastructure and processes that are stored or located in the Cloud is: 95%.
A Cloud can be defined as the elastic leasing of pooled computer resources (physical hardware) over the Internet and through the use of virtualization.
Accenture is one of the world's largest management and technological consulting company that provide services such as:
Database managementConsultingStrategy planningOutsourcingBasically, Accenture help business organizations in the implementation of data governance and management policies, in order to ensure the organization's data is trustworthy and reliable.
In 2015, Accenture started its own Cloud journey after recognizing the significant advantages it stand to gain or benefit in leveraging Cloud capabilities at a larger scale.
Consequently, the percentage of Accenture's infrastructure and processes that are stored or located in the Cloud is 95 percent.
Read more: https://brainly.com/question/23844088
the manager of a xyz organisation is preparing the organizational chart which feature of MS Excel /he will use to do so? also write the steps for this
Answer:
Smart Art
Explanation:
The smart art feature in Microsoft excel allows for the creation of organizational chart on Microsoft excel. It readily allows for an hierarchical arrangement of an organization's personnel including the various departments on the system. The smartart allows the implementation of a graphical output which allows the display of an organization's personnel in order of hierarchy. To get started with smart art on excel, Clicking on the insert tab, the same are appears under illustrations. For an organizational chart, the Hierarchy smart art graphic type is selected and filled accordingly.
a person who creates a computer virus is called
Answer:
A person who creates computer virus is known as hacker.
PLEASE HELP ME! Sam was researching rocks and minerals. He thought the Web site looked unprofessional, so he looked for the author's information or credentials. He couldn't find any. Is this site reliable? A. Probably B. Probably not.
Answer:
B
Explanation:
If a site looks unprofessional and doesn't have any credentials, those are two signs that it's probably not very reliable.
Shawn has connected his laptop to a projector and chosen to duplicate his screen to the projector. Which statement is true in this situation regarding the Presenter view?
It will be used by default.
It will not be used by default but can be selected.
It cannot be used.
It must be used.
Answer:
B. It will not be used by default but can be selected.
Explanation:
PowerPoint application can be defined as a software application or program designed and developed by Microsoft, to avail users the ability to create various slides containing textual and multimedia informations that can be used during a presentation.
Some of the features available on Microsoft PowerPoint are narrations, transition effects, custom slideshows, animation effects, formatting options etc.
Basically, the views that are available on the Microsoft PowerPoint application includes;
1. Slide Sorter.
2. Notes Page.
3. Reading Pane.
4. Presenter view.
Presenter view avails the user an ability to use two monitors to display his or her presentation. Thus, one of the monitors displays the notes-free presentation to your audience while the other monitor lets you view the presentation with notes that you have added to the slides, as well as the navigation and presentation tools.
In this scenario, Shawn has connected his laptop to a projector and chosen to duplicate his screen to the projector. Hence, the statement which is true in this situation regarding the Presenter view is that it will not be used by default but can be selected by the user.
How can identity theft be prevented?
Answer:
Identity theft can be prevented by using proper security measures
Explanation:
Identity theft can be prevented by using proper security measures such as stronger passwords and VPN. It can also be protected by making sure your system security is up to date.
PLS HELP ASAP) Omar is using the web to do research on diabetes. he needs to ensure that all of the information he finds regarding medications, treatments, and diets are accurate. the first websites he finds has a lot of information about a diet plan to help diabetic live healthy lifestyle. Omar can't figure out who the author of the site is and he notices that matches the one described on the website. Which of these are red flags that he should continue doing more research elsewhere? choose the right answer
a. the content is biased towards a particular diet plan that the site is advertising
b. Omar cant find the author so there is no proof that the writer can be trusted to provide medical advice.
c. both A and B
d. none of the above. the website can be trusted.
Nikolas is doing research on U.S visas for a school project. he has found conflicting information on two sites. the first site is travel.state.gov and the other is traveldocs.com which site should Nikolas trust more? choose the answer
a. Travel.state.gov
b. Traveldocs.com
Answer: 1. C. both A and B.
2. Travel.state.gov
Explanation: i took the test!
Que ventajas podria traer el internet a la educacion artistica? Ayuda porfa telo pido porfavor
Answer:
"Informacion"
Explanation:
La internet puede traer las mismas ventajas para la educacion artistica que cualquier otra materia y eso es "Informacion". El arte tiene muchas tecnicas. Tambien hay muchos differentes estilos de arte. La internet tiene toda la informacion sobre los artistas mas famosos de las historia, incluyendo su arte, tecnicas, estilos, temas, historias, etc. Esta informacion es sumamente importante y util por que te enseña a utilizar todos los metodos ya creados y usarlos como herramientas para crear arte que representa el artista que sos.
A person who creates a computer virus is a (1)system analyst (2) techician(3) programmer
Answer:
a person who creates a computer virus is a programmer
Answer: hacker
Explanation:
Which of the following allows you to copy
formatting of text from one part of your presentation
and apply it to text in another part of your
presentation?
Animation Painter
Animation
Format Painter
slide master
DONE
Answer:
format painter
Explanation:
A writing guide in making a project correctly.
a.project proposal
b.project plan
c.project format
d.project template
Answer:
b
Explanation: