To address database failure (if the system crashes), what type of redundancy would you recommend to address this?

Pick three security concerns of database system and explain how you would address them.

advantages of using a protien sequence rather than a DNA sequence when searching the bioinformatics database

Bryan is performing data entry for an insurance company by taking handwritten records and entering them into the database. Thus far, 1.8% of the handwritten records have had missing data that prevented them from being entered into the database. If the probability that the first record with missing data is found within the first five records is greater than 5%, Bryan will stop data entry and ask for more information. Will Bryan stop entering data? Use Excel to find the probability, rounding to three decimal places.

At a fundamental level of analysis, we can conceive of the ‘point of sale’ data capture of a business event, transaction processing, data storage, and ultimately data analysis and production of a business intelligence (BI) report. Explain how this overall sequence of activities occurs. Your explanation should focus the role of the TPS (1 mark), the two major processing options that may be used by the TPS , the role and major limitation of the production database (1 mark), and finally the role of the OLAP database (1 mark).

Database - SQL - Operations

CS 203 Discrete Structure 2

Create a Microsoft Access Database consisting of the following two tables: Part_needs and Parts_Inventory

Answer the following questions:

1. What are the operations that correspond to the query expressed using this SQL statement?

SELECT Supplier

FROM Part_needs

WHERE 1000<= Part_number <= 5000

2. What is the result of the corresponding query, created using Access Database given Part_needs table as input?
3. What are the operations that correspond to the query expressed using this SQL statement?

SELECT Supplier, Project                                                                                                                                

FROM Part_needs, Parts_inventory

WHERE Quantity <= 10

4. What is the output of the corresponding query created ,using Microsoft Access Database t given Part_needs, and Parts_inventory

Consider an ONLINE_AUCTION database system in which members (buyers and sellers) participate in the sale of items. Design an ER/EER diagram for this ONLINE_AUCTION database. The data requirements for this system are summarized as follows:
• The online site has members, each of whom is identified by a unique member number and is described by an e-mail address, name, password, home address, and phone number.
• A member may be a buyer or a seller. A buyer has a shipping address recorded in the database. A seller has a bank account number and routing number recorded in the database.
• Items are placed by a seller for sale and are identified by a unique item number assigned by the system. Items are also described by an item title, a description, starting bid price, bidding increment, the start date of the auction, and the end date of the auction.
• Items are also categorized based on a fixed classification hierarchy (for example, a modem may be classified as COMPUTER → HARDWARE → MODEM).
• Buyers make bids for items they are interested in. Bid price and time of bid is recorded. The bidder at the end of the auction with the highest bid price is declared the winner and a transaction between buyer and seller may then proceed.
• The buyer and seller may record feedback regarding their completed transactions. Feedback contains a rating of the other party participating in the transaction (1–10) and a comment.

Database Systems - Security and Administration

Jak University is a leading higher education institution that is well known throughout Malaysia for its academic achievements. It is proven that this university exists in all major cities in Malaysia. Jak University is also in Kuala Lumpur and as a management center, has 100 thousand students and 10 thousand lecturers spread across several branch campuses. The learning process is done face-to-face and online. Each campus in each city can join virtual classes, so that the data from each campus can be connected to one another. Academic data from each campus branch is stored in files and then sent to the Center in Kuala Lumpur and each campus can also share data (share files). However, after this university has been operating for several years, the number of lecture transactions has increased, so that the volume of data stored in files is getting bigger. So in day-to-day operations often experience problems access to data, both when sending data and when accessing data from other campuses.

Question:

1. The University of Jak uses a file-based approach in managing its academic data. But over time began to experience problems with data accessibility.
You were appointed as a Database Consultant to change the data management process at the University of Jak using a database approach. You need to explain to the Management in Kuala Lumpur so that the leaders can understand and be sure about the proposed application of the database approach, where this approach can support operational performance in data management. Explain what is meant by a file-base approach and a database approach. Also describe the advantages and disadvantages of each.

2. If the management approves the proposal, then you need to design a good database architecture. You can choose a Three-Tier Client-Server architecture.

3. The hardware running the DBMS must continue to operate even if one of the hardware components is damaged due to various factors. One solution is to implement RAID technology. Describe what RAID technology is. Also explain by providing examples of how each RAID level is implemented.