first course CS,SE,IT.zip
6 MB
Programming 1 (cpp)
introduction of computer Science
And Final exam (programming 1)
introduction of computer Science
And Final exam (programming 1)
π
π
π
’π
£ π
¦π
π
π
’π
π
£π
-----------------------
π α¨α°αα«α© software α¨α crake file
like βοΈadobe products
βοΈ Operating system
βοΈ Programming app
and more πβπ¨
download αα¨α α΅α½αααΉ α αͺα website ααΈα
π allpcworld.com
π getintopc.com
ββββββ
Join The Underground Coding Movement!
AI Programming @freecodecs
-----------------------
π α¨α°αα«α© software α¨α crake file
like βοΈadobe products
βοΈ Operating system
βοΈ Programming app
and more πβπ¨
download αα¨α α΅α½αααΉ α αͺα website ααΈα
π allpcworld.com
π getintopc.com
ββββββ
Join The Underground Coding Movement!
AI Programming @freecodecs
OOP Ex-2 (Java)
βββββββββ
βAccountβ type has the following members :
β’ Balance
β’ Rate
β’ Deposit
β’ Withdraw
β’ Interest Calculation
βSaving Accountβ is a type of account that implements βAccountβ as follows
β’ A client can not withdraw more than 80% of their balance
β’ Interest rate is 8%
β’ A client is charged 5% of their withdrawal amount every time they withdraw
βCurrent Accountβ implements βAccountβ and has the following characteristics
β’ A client can withdraw upto 90% of their balance with minimum withdraw of 2000
β’ Interest rate is 12%
β’ Not charged for withdrawal
Q. Solve this problem using Java programming language.
βββββββββ
Join The Underground Coding Movement!
AI Programming @freecodecs
βββββββββ
βAccountβ type has the following members :
β’ Balance
β’ Rate
β’ Deposit
β’ Withdraw
β’ Interest Calculation
βSaving Accountβ is a type of account that implements βAccountβ as follows
β’ A client can not withdraw more than 80% of their balance
β’ Interest rate is 8%
β’ A client is charged 5% of their withdrawal amount every time they withdraw
βCurrent Accountβ implements βAccountβ and has the following characteristics
β’ A client can withdraw upto 90% of their balance with minimum withdraw of 2000
β’ Interest rate is 12%
β’ Not charged for withdrawal
Q. Solve this problem using Java programming language.
βββββββββ
Join The Underground Coding Movement!
AI Programming @freecodecs
AI Programming pinned Β«OOP Ex-2 (Java) βββββββββ βAccountβ type has the following members : β’ Balance β’ Rate β’ Deposit β’ Withdraw β’ Interest Calculation βSaving Accountβ is a type of account that implements βAccountβ as follows β’ A client can not withdraw more than 80% of theirβ¦Β»
Problem Workflow Tester
OOP Ex-2 (Java) Continues.
βββββββββ
Do the problem with this tester
1) βAbebeβ opened a βSaving Accountβ with initial deposit of 1,000
β’ make deposit of the following amounts at different time
- 1,500
- 500
- 2,000
β’ calculate interest
β’ make the following withdrawals
- 2,000
- 800
- 1,000
^ What will be his net balance at the end of the above transactions?
2) βAsterβ opened a βCurrent Accountβ with initial deposit of 5,000
β’ make deposit of the following amounts
- 2,000
- 3,000
β’ calculate interest
β’ make the following withdrawals
- 4,000
- 2,500
^ What will be her net balance at the end of the above transactions?
N.B. This is an example of how to speed up your process of solving the problem, not a rule to follow. Release your creativity such as by accepting variables from user, creating more dynamic class members & minimizing errors by using exceptions handlers.
Peace βπ½ out !
βββββββββ
Join The Underground Coding Movement!
AI Programming @freecodecs
OOP Ex-2 (Java) Continues.
βββββββββ
Do the problem with this tester
1) βAbebeβ opened a βSaving Accountβ with initial deposit of 1,000
β’ make deposit of the following amounts at different time
- 1,500
- 500
- 2,000
β’ calculate interest
β’ make the following withdrawals
- 2,000
- 800
- 1,000
^ What will be his net balance at the end of the above transactions?
2) βAsterβ opened a βCurrent Accountβ with initial deposit of 5,000
β’ make deposit of the following amounts
- 2,000
- 3,000
β’ calculate interest
β’ make the following withdrawals
- 4,000
- 2,500
^ What will be her net balance at the end of the above transactions?
N.B. This is an example of how to speed up your process of solving the problem, not a rule to follow. Release your creativity such as by accepting variables from user, creating more dynamic class members & minimizing errors by using exceptions handlers.
Peace βπ½ out !
βββββββββ
Join The Underground Coding Movement!
AI Programming @freecodecs
NOTICE
βββββββββ
The code must display the above question as shows/ attached here βπ½
βββββββββ
Join The Underground Coding Movement!
AI Programming @freecodecs
Have a Nice Figuring-out Folks ππ½
βββββββββ
The code must display the above question as shows/ attached here βπ½
βββββββββ
Join The Underground Coding Movement!
AI Programming @freecodecs
Have a Nice Figuring-out Folks ππ½
Bank.java
3.6 KB
OOP EX-2 JAVA CODE)
βββββββββ
Join The Underground Coding Movement!
AI Programming @freecodecs
Have a Nice Practice Folks ππ½
βββββββββ
Join The Underground Coding Movement!
AI Programming @freecodecs
Have a Nice Practice Folks ππ½
π1
httrack_x64@freecodecs.exe
4.3 MB
it allows you to download Web site from the Internet to a local directory, building recursively all directories, getting HTML, images, and other files from the server to your computer.
πα¨αα΅αααα΅α website offline download αα¨α α΅α½ααα½α π
like w3school.com
Tutorialspoint.com
πα¨αα΅αααα΅α website offline download αα¨α α΅α½ααα½α π
like w3school.com
Tutorialspoint.com
Using Run SQL Command Line
We described the full steps on below post β¬οΈ
βββββββ
AI Programming @freecodecs
Hope this will be helpful ππ½
We described the full steps on below post β¬οΈ
βββββββ
AI Programming @freecodecs
Hope this will be helpful ππ½
Steps Using Run SQL Command Line
ββββββββββββββββββ
Step 1: Open Run SQL Command Line
Step 2: Write and enter the following without quotations and semicolon
βconnect systemβ
Step 3: Enter your password which is you gave when you install Oracle Enterprise program and press enter(*you wonβt see it when you write itβs just blank)
Step 4: Alter the HR database account to access it every time - write and enter the following without the quotation and with the semicolon this time
βalter user hr account unlock;β
Step 5: Now create user and password for manipulation of HR account - also write enter the following without the quotation and with semicolon
βalter user hr identified by hr;β
Step 6: Write and enter βconnectβ then enter user name & pass, write and enter twice βhrβ for the username and password
β’NBβ’ Now you can use the Oracle SQL Program anytime but when you use it on next launch which is after exiting and starting again skip Step 4 & 5
βββββββ
AI Programming @freecodecs
As always :
Have a Lit π₯ Practice Folks ππ½
ββββββββββββββββββ
Step 1: Open Run SQL Command Line
Step 2: Write and enter the following without quotations and semicolon
βconnect systemβ
Step 3: Enter your password which is you gave when you install Oracle Enterprise program and press enter(*you wonβt see it when you write itβs just blank)
Step 4: Alter the HR database account to access it every time - write and enter the following without the quotation and with the semicolon this time
βalter user hr account unlock;β
Step 5: Now create user and password for manipulation of HR account - also write enter the following without the quotation and with semicolon
βalter user hr identified by hr;β
Step 6: Write and enter βconnectβ then enter user name & pass, write and enter twice βhrβ for the username and password
β’NBβ’ Now you can use the Oracle SQL Program anytime but when you use it on next launch which is after exiting and starting again skip Step 4 & 5
βββββββ
AI Programming @freecodecs
As always :
Have a Lit π₯ Practice Folks ππ½
Database Exercise Questions
βββββββ
N.B. Consider the database shown above in Figure DB 1.1, whose schema is shown and do the practical exercises below.
(We assume you have installed Oracleβs default HR(Human Resource) database, itβs comes as a compacted package within the Oracle Enterprise 11G program.)
βββββββββ
Exercise Instruction : Write the SQL command used to manipulate in Oracle SQL Command Line program.
β’Ex 1β’ Select and display all records from jobs table where itβs job title words started with βAβ character
β’Ex 2β’ Display different /not duplicated/ maximum & minimum values of records from jobs table
β’Ex 3β’ Display department names records from departments table whose location IDβs are 1700
β’Ex 4β’ Display all records of jobs table in minimum salary ascending order whose job title had βPβ character in it
β’Ex 5β’ Display first & last name, email, and salary records of employees table whose first name ends with character βyβ in email descending order
β’Ex 6β’ Display first name, last name and salary records from employees table whose salary is either 12008 or 3000
β’Ex 7β’ Display city and postal code records whose last character of city record neither ends with βyβ, βeβ nor βaβ from locations table
β’Ex 8β’ Display employee Id, first name, phone number and email records from employees table whose hires 4000 days before server date
β’Ex 9β’ Display average, minimum and maximum salary values only by using functions from employees table
β’Ex 10β’ Display employees of first name, last name and salary records whose hire date is January 07 2002 and whose salary is either 6500 or 8300
For SQL Commands reference please review the pdf short note attached and pined earlier.
βββββββ
AI Programming @freecodecs
Have a Litπ₯ Practice Folks ππ½
βββββββ
N.B. Consider the database shown above in Figure DB 1.1, whose schema is shown and do the practical exercises below.
(We assume you have installed Oracleβs default HR(Human Resource) database, itβs comes as a compacted package within the Oracle Enterprise 11G program.)
βββββββββ
Exercise Instruction : Write the SQL command used to manipulate in Oracle SQL Command Line program.
β’Ex 1β’ Select and display all records from jobs table where itβs job title words started with βAβ character
β’Ex 2β’ Display different /not duplicated/ maximum & minimum values of records from jobs table
β’Ex 3β’ Display department names records from departments table whose location IDβs are 1700
β’Ex 4β’ Display all records of jobs table in minimum salary ascending order whose job title had βPβ character in it
β’Ex 5β’ Display first & last name, email, and salary records of employees table whose first name ends with character βyβ in email descending order
β’Ex 6β’ Display first name, last name and salary records from employees table whose salary is either 12008 or 3000
β’Ex 7β’ Display city and postal code records whose last character of city record neither ends with βyβ, βeβ nor βaβ from locations table
β’Ex 8β’ Display employee Id, first name, phone number and email records from employees table whose hires 4000 days before server date
β’Ex 9β’ Display average, minimum and maximum salary values only by using functions from employees table
β’Ex 10β’ Display employees of first name, last name and salary records whose hire date is January 07 2002 and whose salary is either 6500 or 8300
For SQL Commands reference please review the pdf short note attached and pined earlier.
βββββββ
AI Programming @freecodecs
Have a Litπ₯ Practice Folks ππ½
DB - Oracle Exercise 1 :Answers
ββββββββββββββββ
β’Ans Ex 1
SELECT * FROM JOBS WHERE JOB_TITLE LIKE β%A_%β;
β’Ans Ex 2
SELECT DISTINCT MIN_SALARY, MAX_SALARY FROM JOBS;
β’Ans Ex 3
SELECT DEPARTMENT_NAME FROM DEPARTMENTS WHERE LOCATION_ID = 1700;
β’Ans Ex 4
SELECT * FROM JOBS WHERE JOB_TITLE LIKE β%P%β ORDER BY MIN_SALARY;
(SELECT * FROM JOBS WHERE JOB_TITLE LIKE β%P%β ORDER BY ASC MIN_SALARY;)
β’Ans Ex 5
SELECT FIRST_NAME, LAST_NAME, EMAIL, SALARY FROM EMPLOYEES WHERE FIRST_NAME LIKE β%yβ ORDER BY EMAIL DESC;
β’Ans Ex 6
SELECT FIRST_NAME, LAST_NAME, SALARY FROM EMPLOYEES WHERE SALARY = 12008 OR SALARY = 3000;
β’Ans Ex 7
SELECT CITY, POSTAL_CODE FROM LOCATIONS WHERE CITY NOT LIKE β%eβ AND CITY NOT LIKE β%yβ AND CITY NOT LIKE β%aβ;
β’Ans Ex 8
SELECT EMPLOYEE_ID, FIRST_NAME, PHONE_NUMBER, EMAIL FROM EMPLOYEES WHERE HIRE_DATE > SYSDATE - 4000;
β’Ans Ex 9
SELECT MAX(SALARY) as βMax Salaryβ, MIN(SALARY) as βMin Salaryβ, AVG(SALARY) as βAverage Salaryβ FROM EMPLOYEES;
β’Ans Ex 10
SELECT FIRST_NAME, LAST_NAME, SALARY FROM EMPLOYEES WHERE HIRE_DATE = β07-JUN-02β AND (SALARY = 6500 OR SALARY = 8300);
βββββββ
AI Programming @freecodecs
Have a Litπ₯ Practice Folks ππ½
ββββββββββββββββ
β’Ans Ex 1
SELECT * FROM JOBS WHERE JOB_TITLE LIKE β%A_%β;
β’Ans Ex 2
SELECT DISTINCT MIN_SALARY, MAX_SALARY FROM JOBS;
β’Ans Ex 3
SELECT DEPARTMENT_NAME FROM DEPARTMENTS WHERE LOCATION_ID = 1700;
β’Ans Ex 4
SELECT * FROM JOBS WHERE JOB_TITLE LIKE β%P%β ORDER BY MIN_SALARY;
(SELECT * FROM JOBS WHERE JOB_TITLE LIKE β%P%β ORDER BY ASC MIN_SALARY;)
β’Ans Ex 5
SELECT FIRST_NAME, LAST_NAME, EMAIL, SALARY FROM EMPLOYEES WHERE FIRST_NAME LIKE β%yβ ORDER BY EMAIL DESC;
β’Ans Ex 6
SELECT FIRST_NAME, LAST_NAME, SALARY FROM EMPLOYEES WHERE SALARY = 12008 OR SALARY = 3000;
β’Ans Ex 7
SELECT CITY, POSTAL_CODE FROM LOCATIONS WHERE CITY NOT LIKE β%eβ AND CITY NOT LIKE β%yβ AND CITY NOT LIKE β%aβ;
β’Ans Ex 8
SELECT EMPLOYEE_ID, FIRST_NAME, PHONE_NUMBER, EMAIL FROM EMPLOYEES WHERE HIRE_DATE > SYSDATE - 4000;
β’Ans Ex 9
SELECT MAX(SALARY) as βMax Salaryβ, MIN(SALARY) as βMin Salaryβ, AVG(SALARY) as βAverage Salaryβ FROM EMPLOYEES;
β’Ans Ex 10
SELECT FIRST_NAME, LAST_NAME, SALARY FROM EMPLOYEES WHERE HIRE_DATE = β07-JUN-02β AND (SALARY = 6500 OR SALARY = 8300);
βββββββ
AI Programming @freecodecs
Have a Litπ₯ Practice Folks ππ½
AI Programming pinned Β«Database Exercise Questions βββββββ N.B. Consider the database shown above in Figure DB 1.1, whose schema is shown and do the practical exercises below. (We assume you have installed Oracleβs default HR(Human Resource) database, itβs comes as a compactedβ¦Β»
πα¨α°αα«α© programming language video/course α°α¨ααΈαα α¨α α α α₯α α¨α exercise file,software ααα΅ααα @alphacoder12
αα inbox me
βα¨ YouTube video α αα°ααβ
βοΈ Java βοΈ PHP
βοΈ html/css βοΈJavaScript
βοΈ Android studio βοΈFlutter
βοΈAndroid Oreo developer
...α¨αα³α°αα΅α
- Softwares
- application
- pc formatting
contact us
@alphacoder12
βοΈ 0993809248
αα inbox me
βα¨ YouTube video α αα°ααβ
βοΈ Java βοΈ PHP
βοΈ html/css βοΈJavaScript
βοΈ Android studio βοΈFlutter
βοΈAndroid Oreo developer
...α¨αα³α°αα΅α
- Softwares
- application
- pc formatting
contact us
@alphacoder12
βοΈ 0993809248