Answer all questions

Q1 Create sequence test_seq, starting with value 300, each value should be 150 less than previous value, with smallest value to be 0 and no cycle.

Q2 Show NEXTVAL generated by sequence four times. Use DUAL table to show values. Why was error generated for 4th execution? View current value of your sequence. Then drop your sequence.

Q3 Create bitmap index on table ORDERS to speed the search for orders based on shipstate. Query index, then delete it.

Q4 Add an index for the customer's last name

Q5 Add an index on the number of days it took to ship the order. If shipdate is unavailable, use January 1, 2020 for the calculations.

Q6 There seems to be some confusion in data entry about book titles due to similar titles. For example, Golden Son by Pierce Brown vs. The Golden Son by Shilpi Somaya Gowda. Add a unique constraint for the book title. Can you add a unique constraint to a column containing duplicate data?

Q7 Make sure that all book records have a title, publisher, cost, and retail, and that all publishers have contact and phone. Think about new constraints to add by ALTERing the books table.

Q8 Add a constraint so that all retail prices have to be between $2 and $200

Resolving Outstanding Financial Obligations One of the most important things for business owners to consider is whether they have outstanding financial obligations that need to be resolved before the business ceases operation. This can include renting office space where the business owner holds the title or any personal assets used as collateral for business debts. Proactively communicating with vendors, lenders, and suppliers can help business owners determine what to pay off when and the available options for doing so. Maintaining Records During the entire dissolution process, it's important for business owners to keep detailed records of the proceedings in a safe place. Standard dissolution guidelines typically require these records to be kept for up to seven years in the event future litigation arises. Posted in Commercial Litigation Tagged Dissolution of Business Article is available at https://feldman. lawews/what-to-consider-when-going-through-the- dissolution-of-a-business-due-to-covid-19/ Answer the questions below based on the excerpt given. a) Briefly explain THREE (3) methods for dissolution of partnership provided under Partnership Act 1961 by taking into consideration the effects of Covid 19 to the business of partnership. (15 marks) (CLO1: PLO1: C2) b) Provide TWO (2) types of partner's liability that need to be considered before the dissolution of partnership. (10 marks) (CLO1: PLOI: C2)Use case and OFD level , DFD level 1, OFD level 2 for at least one process for BADAR ALSAMA HOSPITAL ?: 26 01 30 Question 28 (1 point) Saved The Canada Pension Plan (CPP) and the Quebec Pension Plan (QPP) are: O A) mandatory plans. O B) optional, mandatory, and contributory plans. ( C) optional plans. OD) contributory plans. E) mandatory and contributory plans.System analysis and design CS 240 Take Home Exam (6 Marks) Read the system carefully Pharmacy Information System The customer can buy a drug, take it back, or inquire about its price The pharmacist can add medicines to the system, delete them, and adjust their price. The manager can create reports and add pharmacists to the system The system can print an invoice for the customer for what he bought from the pharmacy if the customer wanted to do so. Questions: 1. Draw a Context Diagram for this system( 2 Marks) 2. Draw Level 0 DFD for this system (2 marks) 3. Draw Use Case for this system (2 marks)4. Consider the two E-R diagrams in Figure 2-24, which repre- sent a database of community service agencies and volun- teers in two different cities (A and B). For each of the following three questions, place a check mark under City A, City B, or Can't Tell for the choice that is the best answer. FIGURE 2-24 Diagram for Problem and Exercise 4 City A City's Assists Assists AGENCY 0 VOLUNTEER AGENCY # 04 VOLUNTEER City A City B Can't Tell a. Which city maintains data about only those volunteers who currently assist agencies? b. In which city would it be possible for a volunteer to assist more than one agency? c. In which city would it be possible for a volunteer to change which agency or agencies he or she assists