CST225Quiz4 Done
.docx
School
North Carolina A&T State University *
*We aren’t endorsed by this school
Course
225
Subject
Electrical Engineering
Date
Apr 3, 2024
Type
docx
Pages
6
Uploaded by DeanMoon9058
CST225
Quiz#4: SQL I Spring2024
Problem: Reading quiz.
Note
:
Please read/review the lecture notes for basic SQL chapter in preparation for this quiz. XAMPP is REQUIRED!!! (See how to download Xampp in the software folder located on Blackboard. Go over the slides then write
, run
the SQL queries for the following questions and show the result of each query. (
SCREENSHOTS OF SYNTAXES AND RESULTS).
You can either use XAMPP shell, the command prompt or php admin please see lab 4
Noah Thompson
1.
Connect to mysql 2.
Show all the databases.
3.
Create a new database called "lastname_db".(where lastname is your last name)
Page | 1
CST225
Quiz#4: SQL I Spring2024
4.
Set the "lastname_db"(where lastname is your last name) database as the default database.
5.
Show all the tables in the default database.
6.
Create a new table called "Departments" with the columns and type indicated below. deptName
VARCHAR(20)
building
VARCHAR(15)
budget
FLOAT(12,2)
Biology
Watson
90000.00
Comp.Sci.
Taylor
100000.00
Elec.Eng.
Taylor
85000.00
Finance
Painter
120000.00
7.
Insert the above records in the Departments Table
Page | 2
CST225
Quiz#4: SQL I Spring2024
8.
Create another new table called "Instructors" with the columns and type indicated below.
ID
CHAR(5)
name
VARCHAR(30)
deptName
VARCHAR(20)
salary
FLOAT(10,2)
12121
Alice Wu
Finance
90000.00
15151
John Mozart
Music
40000.00
22222
Frank Einstein
Physics
95000.00
32343
El Said
History
60000.00
33456
Chelsea Dunn
Physics
90000.00
9.
Insert the above records in the Instructors Table
10. Delete from the departments table the comp.Sci. Department
Page | 3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
The numbers from 0-9 and a no characters
is the Basic 1 digit seven segment display
* .can show
False
True
In a (CA) method of 7 segments, the
anodes of all the LED segments are
* "connected to the logic "O
False
True
Some times may run out of pins on your
Arduino board and need to not extend it
* .with shift registers
True
False
arrow_forward
Question 7 election
Assume we have to add two 6-bit numbers in signed integer form. Perform the binary addition and indicate if an overffow occurs. To check, convert both binary operends and your binary sum answer to decimal numbers. . .......
.....................
Full explain this question and text typing work only thanks.
arrow_forward
Solve the problem and simplify the output function using Quine–Mc Cluskey Methods. The following requirements must be met in solving the problem.
Requirement:a. Truth Tableb. Timing Diagramc. Quine – Mc Cluskey Method d. Logic Diagram
A private company wants to decide on a certain issue. Each of the four officials has an equal share of voting right. At least two of them must approve the solution in order to implement it. Each of them has a switch which closes to vote YES and open to vote NO.
arrow_forward
1) Here is a Digital Logic question on registers and counters with the answer. Please explain what the teacher did and why they did it. I need you to explain how they got the answer.
arrow_forward
Question 7 election
Full explain this question and text typing work only thanks.
arrow_forward
logic gates karnaugh maps
arrow_forward
What is the function of the odd parity generator circuit?
O a. produces an output of 'I' for even number of logic T
O b. produces an output of '0' for odd number of logic T'
O c. produces an output of '1' for odd number of logic T
shift?
What is the difference between a left logical shift and a left arithmet
O a. logical shift feeds a '0' in the MSB
O b. arithmetic shift feeds a '0' in the MSB
O c. no difference
arrow_forward
5. Write an assembly language program to convert an 8-bit binary data to
BCD. The binary data is stored in 4200H. Store the hundred's digit in 4251H.
store the ten's and unit's digits in 4250H
arrow_forward
Can someone please help me solve this please
arrow_forward
Given the diagram.
a.) What is the boolean algebraic equation for Q in terms of A and B?
b.) Create a four state truth table for Q in terms of A and B
c.) What gate this the diagram represent?
arrow_forward
1) What is the biggest binary number (decimal value) you can write with 6 bits?
What is the biggest binary number (decimal value and in terms of n) you can write
with n bits?
If you want to represent the decimal numbers from 0-16, what is the minimum
number of bits you will need?
Convert the decimal number 238 to binary number. (ZERO point if not showing
steps/calculation!)
arrow_forward
a) Convert the decimal number - 239 into a
signed binary number using
(1) sign-magnitude method (2) 1's
complement method (3) 2's complement
method
b) If the above decimal number is positive ,
that is + 239, then convert it to a signed
binary number using 1 's complement
method
c) Do the following binary subtraction:
101111111.01111-
001011010.10110
d)Explain Types of RAM?
arrow_forward
%00 |1.
* M 1::Y)
0 Chapter #01_HW#..
->
Chapter #1 Programmable Logic Devices
HW # 01
Q. Please specify the following sentences are TRUE or FALSE:
1. A PAL consists of a programmable array of OR gates connected to a fixed array of AND gates.
2. SPLD stands for simple programmable logic device.
3. Typically, a macrocell consists of an AND gate and its associated output logic.
4. CPLD stands for complex programmable logic device.
5. An FGPA is a field programmable gate array.
6. A typical FPGA has a greater gate density than a CPLD.
7. Logic array blocks are found in CPLDS.
8. The process of programming a PLD is known as design flow.
Electrical Engineering Department/ University of Barah
•..
arrow_forward
Please solve it fast
arrow_forward
On a digital circuit with three switch inputs, LED operates when two or three of the switches
are 1' position.
a. Prepare the accuracy table of this process.
b. Write logic equation according to the accuracy table and simplify the logic equation using
rules of boolean algebra.
c. Simplify the logic equation using Karnaugh map and draw the door circuit
arrow_forward
Q4/ The decimal
793.251)= (
number
1431.204
number (
O 1431.200
O No one of them
1341.200
O 1341.201
) in octal
arrow_forward
The binary number 1010 0011 is an ?even or odd? number that has?even or odd? parity?
arrow_forward
3. Add the following 5-bit signed binary numbers together. Please indicate if overflow occurs.
a. 00100 + 11000
b. 01010 + 01000
c. 11010 + 10011
Your answer
arrow_forward
Electrical Engineering
Draw 2, 1 bit ALUS to create a basic 2 bit
ALU. the carry out and carry in bits must
ripple across. The ALU should subtract/add,
logical NOR, logical AND, and logical OR.
Draw out the adding logic circuit
arrow_forward
Write Logic expressions for outputs and draw logic diagram for 1 to 4 demux.
arrow_forward
Show a step by step solution.
arrow_forward
Can you answer these two questions and show all steps please:What is the decimal equivalent of the largest integer that can be expressed with 22 bits, using 1’scomplement representation?
What is the decimal equivalent of the smallest integer that can be expressed with 21 bits, using 2’scomplement representation?
arrow_forward
I need an expert solution for handwriting, correct and complete please.
arrow_forward
Create a circuit to generate odd parity bit for a 3-bit code.
a. Construct the truth table.
b. Use K-map to simplify the circuit.
c. Draw the circuit with minimum number of gates.
(I did the question myself, but I'm confused as to why the K-map does not provide the simplified circuit to build the minimum number of gates)
arrow_forward
1. provide an handwritten answer please For (d) & (e)
arrow_forward
1. Derive a Boolean expression for the following digital circuit and sketch the true table.
A
B
X
C
arrow_forward
URGENT!
PLEASE ANSWER COMPLETELY.
WILL GIVE UPVOTE :)
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- The numbers from 0-9 and a no characters is the Basic 1 digit seven segment display * .can show False True In a (CA) method of 7 segments, the anodes of all the LED segments are * "connected to the logic "O False True Some times may run out of pins on your Arduino board and need to not extend it * .with shift registers True Falsearrow_forwardQuestion 7 election Assume we have to add two 6-bit numbers in signed integer form. Perform the binary addition and indicate if an overffow occurs. To check, convert both binary operends and your binary sum answer to decimal numbers. . ....... ..................... Full explain this question and text typing work only thanks.arrow_forwardSolve the problem and simplify the output function using Quine–Mc Cluskey Methods. The following requirements must be met in solving the problem. Requirement:a. Truth Tableb. Timing Diagramc. Quine – Mc Cluskey Method d. Logic Diagram A private company wants to decide on a certain issue. Each of the four officials has an equal share of voting right. At least two of them must approve the solution in order to implement it. Each of them has a switch which closes to vote YES and open to vote NO.arrow_forward
- 1) Here is a Digital Logic question on registers and counters with the answer. Please explain what the teacher did and why they did it. I need you to explain how they got the answer.arrow_forwardQuestion 7 election Full explain this question and text typing work only thanks.arrow_forwardlogic gates karnaugh mapsarrow_forward
- What is the function of the odd parity generator circuit? O a. produces an output of 'I' for even number of logic T O b. produces an output of '0' for odd number of logic T' O c. produces an output of '1' for odd number of logic T shift? What is the difference between a left logical shift and a left arithmet O a. logical shift feeds a '0' in the MSB O b. arithmetic shift feeds a '0' in the MSB O c. no differencearrow_forward5. Write an assembly language program to convert an 8-bit binary data to BCD. The binary data is stored in 4200H. Store the hundred's digit in 4251H. store the ten's and unit's digits in 4250Harrow_forwardCan someone please help me solve this pleasearrow_forward
- Given the diagram. a.) What is the boolean algebraic equation for Q in terms of A and B? b.) Create a four state truth table for Q in terms of A and B c.) What gate this the diagram represent?arrow_forward1) What is the biggest binary number (decimal value) you can write with 6 bits? What is the biggest binary number (decimal value and in terms of n) you can write with n bits? If you want to represent the decimal numbers from 0-16, what is the minimum number of bits you will need? Convert the decimal number 238 to binary number. (ZERO point if not showing steps/calculation!)arrow_forwarda) Convert the decimal number - 239 into a signed binary number using (1) sign-magnitude method (2) 1's complement method (3) 2's complement method b) If the above decimal number is positive , that is + 239, then convert it to a signed binary number using 1 's complement method c) Do the following binary subtraction: 101111111.01111- 001011010.10110 d)Explain Types of RAM?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you