Databases Questions and Answers April 12, 2018

Database Models and Legacy Systems Databases evolved from flat file systems. As technology advanced, the limitations of flat files became evident. The database model has evolved to meet the business needs of the time. As the information age evolved, organizations realized there was a need for a different type of management system, one that could

Create a presentation about databases. Include a definition, how they are used, objects found in a database (tables, queries, columns, keys, etc.) and include definitions of those. You can also discuss the different brands of database management systems available on the market and any differences. Include any other information you would find

I want a database, table and insert the data into the table .

Customers CustomerID Customer name 1 Joe 2 Jim 3 Carl 4 Sam 5 Harry Orders Order Order ID CustomerID Total 1 2 50 2 2 475 3 4 50 4 4 75 5 4 100 6 5 535

A data definition also known as data description language ( DDL ) is a language used for defining data structures for database schemas. DDL statements create, modify, and delete database objects such as tables, views, indexes, procedures, and users. Commonly used DDL statements are CREATE (creating new objects), ALTER (modifying existing objects),

Apply principles of the systems development life cycle (SDLC) in your proposal by including the SDLC phases listed below into your presentation. You may copy and paste elements from past assignments that apply to the SDLC. Planning Analysis (What are the requirements of the current system's end user?) Detailed Systems Design (Completes the design

Write a two to three (2-3) page paper in which you: Describe the steps that you would use in order to convert database tables to the First Normal Form, the Second Normal Form, and the Third Normal Form. Provide one (1) example that is relevant to a college environment that illustrates reasons for converting database tables to the First, Second,

Do You Know What It Takes to Design an HRIS Database Management System (DBMS)?: Please respond to the following: First, watch the following two (2) videos from thelynda.com course Relational Database Fundamentals with Adam Wilbert. Then, respond to the discussion question that follows. What is a database management system (DBMS)? (4 min 36 s),

the subject is database and it is about recovery.

Database Recovery A) Using simple UNDO and REDO techniques, what actions are taken for T1, T2, and T3 in the following schedule logs Include what values each data item is restored to, as well as any additional log entries that are required. Schedule 1 Schedule 2 Schedule 3 Recovery Actions Schedule 1 Schedule 2 Schedule 3 B) Will the following

CSD 4203 Database Programming Practical exercise 4 Exceptions 1) Run provided SQL script and create Employees table if you have not one. 2) Write PLSQL program to ask user to enter employee ID, and find the employee with this id and read hisher salary. In order to assign value to employee id variable, use substitution variable if you use SQL

Database Design please assist the options are listed please select one for each

DATABASE DEVELOPMENT LIFE CYCLE In which step(s) in the Database Development Life Cycle, would each of the following be performed Obtaining a reasonable estimate of the operating cost of a database system Determining changes needed to make the database more effective. Writing and testing database application programs Determining whether the

What is the positives and negatives in using the role of a privileged users for database.?

Can you help me with the question below? We all know that databases supply the fuel for the productivity engine in the information age, but at what cost - i.e. what effort is required to initially build (design, implement, and populate with data) in a database in your corporate (where you work now or have worked in the past) and personal databases

develop a threat analysis for the pizza company database ?

Using the same database model shown for the previous question, write the relational algebra query that will Get the student , course , and midterm grade of the enrollments for courses of the CS department. For the toolbar, press ALTF10 (PC) or ALTFNF10 (Mac). BIUS Paragraph n student number, coursenumber ( P V Arial V 10pt QUESTION 4 Considering a

1. What are the advantages of storing data in a SQLite database? 2. What makes SQLite an appropriate choice for an Android application, compared to other relational database management systems, such as MySQL and SQL Server? 3. What are the limitations of SQLite compared to server database management systems, such as MySQL and SQL Server? 4. How

First, watch the following two (2) videos from the lynda.com course Relational Database Fundamentals with Adam Wilbert. Then, respond to the discussion question that follows. What is a database management system (DBMS)? (4 min 36 s), located at

Write a brief description (1 to 3 pages)of the most important things that you learned in database management course. Explain why it is important to you and how it will help you to be more effective in your business future.

Q1a What are the activities a Database Designer will do if using the SDLC to design a Database [10] Q1b List the five main components of Access Database and state their uses Q2 We want to represent information about products in a database. Each product has a description, a price and a code. Suppliers have addresses, phone numbers, and names. Each

Create a PowerPoint presentation that explains database design and the use of the ERD from a management point of view.

give explanation about the following terms A.QBE B.SQL C.OLAP D.Sequel Server

Please help me solve these questions, thank you. Subject: Database administration

N a)SQL statements in Figure 1 are used to gather optimizer statistics. How optimizer statistics can be used to help Database Administrators (DBAs) to maintain a database Suggest THREE (3) ways. SQL SELECT COUNT() FROM hr.employees COUNT() 214 SQL SELECT numrows FROM dbatables 2 WHERE ownerHR AND table nameEMPLOYEES NUM ROWS 107 Figure 1 SQL

Choose an industry and explain how a database would be beneficial to that industry.?

Kindly help with php functions to connect to a database(MySQL) to validate usernames(Numeric) and passwords

How to write a memo to Taylor Ambulance that evaluates database management in health care. Your memo should: Explain data collection standards used in the health care industry. Explain health care data collection forms. Explain health care database designs. Analyze the application of a database in the desktop environment used in the health care

this is a introduction to database design question, i'm stuck. please help solve asap

Subtle Emphasis D N LZ Editing Dictate Editor Reuse Files Voice Editor Reuse Files Q4 Pts 25 Make updates to below table structure. Picture A Name CU ID CUS NAME CUS ZIP CUS Information T Null Type NUMBER(10) VARCHAR2(25) NUMBER(10) Picture B CUS Information T Null Type Name CUSID CUS NAME CUS ZIP CUS PHONE NUMBER(10) VARCHAR2(255) VARCHAR2(10)

What are the main reasons for an potential advantages of distributed databases? Please include references

Vertex databases are one type of database that have recently become popular with artificial intelligence and large language models (LLMs). Pick a vector database implementation (e.g. Amazon OpenSearch, GCP Vertex AI Matching Engine, Pinecone, Honeycomb, Milvus, ..) and either 1) describe the advantages/disadvantages of using it with an LLM

1. What is a transaction 2. What are the transaction properties 3. Suppose your database system has failed. Describe the database recovery process and the use of deferred-write and write-through techniques. 4. Name the three most common concurrent transaction execution problems.

Analyze the application of a database in the desktop environment used in the health care industry. please provide references and examples

. What is the relationship between the SDLC and the DBLC? 2. What does the acronym DBLC mean, and what does a DBLC portray? What are the phases? List and explain. 3. What are business rules? Why are they important to a database designer? 4. What is the data dictionary's function in database design?

What kind of database programs do we have available today? What type of platform does each of them run on? What are the criteria you need to consider in selecting a database program? What is the financial aspect for a business as to what database software they will buy? Must be original content and no more than one page.

You should choose a topic related to Database Administration, write an outline for a paper on the topic, and compile a list of possible sources to use in researching the paper. You should choose one of the topics listed below and focus your outline and research on recent developments in that particular area of database management. Possible Paper

A Querying tables city and country 1 Using INNER JOIN ..ON, write a query that displays the name of cities, the cities population and cities continent. Sort the result by continent, then by city population, then by city name. Note that the field called name is present in the two tables, use a table alias to resolve the conflict. 2 Rewrite

List the three main approaches to database programming. What are the advantages and disadvantages of each approach?

In managing data movement, Ahmad is responsible for deciding the method that will be used to save data. As an experienced database administrator, how can you help Ahmad to analyze the benefits of direct path load against the conventional data load? Elaborate your points and give supporting examples.

what does database vulnerabilities and misconfigurations mean(fully explanation)??

One of the important elements of database is databse security. There are different mechanisms that can be used to ensure database security. Discuss the different security mechanisms that you can use. Discuss their advantages and disadvantages and provide strategy on how you will implement them. Make sure you discuss the minimum of five mechanism ?

How Do Database Systems evolve? 1960s,? 1970s? 1980s, 1990s, 2000s and beyond, Objectives and Focuses. What are the various database applications? Personal? Two Tier Client/Server? Multitier Client/Server? Enterprise? ERP? Datawarehouse?...etc. Book 2: For Workforce, How do you interpret the section of The Workfoce of Today? How different is The

Create the database for your system and importing the data from your .csv file from Microsoft access

How can management deter cyber attacks when upgrading healthcare databases? please provide examples and references

How to integrate google dialogue flow chatbot with database? How to save that data automatically in database using back end codes? requirement: i'm confused how to do it my chatbot intent and entities are ready. For buywithus realestate. If you have any submissions of stage two deliverable please send full solution.

Why are traditional databases called operational or transactional? Why are these databases inappropriate for data analysis? ________________________________________________________________________ ________________________________________________________________________ ________________________________________________________________________

What security features need to be added to health care databases? What are the consequences if not done properly? Provide specific examples and references

Update your database project by normalizing your ERD design to the third normal form. Create a Microsoft Access database using the normalized ERD created in this assignment. Select and establish keys and relationships. I do not understand how to do a ERD and certainly do not know how to update one to normalization.

Choose a pragmatic scenario from your professional working environment (or a working environment you are familiar with or have researched) where either a multi-dimensional database or a relational database would be preferred over the other. analysis should focus on the followingfourcriteria: Data presentation Navigation Performance Ease of

Use Database Design Language (DBDL) to create the normalized tables and fields necessary to complete the Soccer Database. Be sure to note all keys. Use the DBDL you created to implement (create) the database in SQL Server 2012. All tables must be in at least 3NF, all keys must be noted properly and the relationships should be correct.

One of your friends has volunteered to run a soccer League this fall. Heshe asked you if you had any suggestions on how they could keep track of the Players, Referees, Scores, and Sponsors of each Match. You told them that it just so happens that you are taking a Database Design class this semester and you would LOVE to help out and design a

How do databases benefit businesses when using queries, forms, and reports?

Evaluate the tools, technology, and trends that make databases useful to corporations. Provide an example of a corporate database and how your tools and technology would be used in the organization of your choice.

How should the management of health care databases change as the health care industry changes? What are some potential risks? Provide examples and references

In our final project, you will design and build a small business database. Think about the business you would like to use for your final project and look for a data model in our previous assignments that can help you design your final project. I have included the sample service and sales businesses you can use for reference. In a Word document

What is the single biggest problem faced by organizations using relational databases?

The paper (five pages) is focus on Entity/Relation model and relational database. You need to provide the histories of ER Model and relational databases, impacts of using relational databases and origins and development cycles of one the following DBMS systems: Oracle Microsoft SQL server SyBase DB2 MySQL In addition, please provide the statistic

What are the steps in the process one follows when transforming an ERD into a physical database design?

provide a comparative analysis (using specific examples), of relational and non-relational databases in the following terms Performance Scalability Availability Expressiveness Consistency Manageability Integrability Flexibility

Create the state_insert trigger prior to incorporation in the OWNER table to ensure that all the STATE fields of the owners are uppercase in the database. I need a code for that question in SQL.

1. Look for 1 case of Database System implementation using the Database System Development Lifecycle (DSDLC) method 2. Explain in detail starting from what the project planning looks like 3. Does the DB System work effectively? If so why and no why? 4. What are the advantages and disadvantages of the method used in developing the DB System? 5. How

Define what a relational database is and describe the importance to an organization and why securing it is important. Provide a database schema in tabular format and provide the necessary SQL statements to build it for three tuples and three attributes each.

Can you do one more assignment Two assignment total: See below Rubric also attached: Details: In the final phase of the Database Design Proposal assignment, you are required to design a working prototype of the proposal. You will be required to utilize SQLite Database. The SQLite database is a small, lightweight database application, suited for

In your own words, describe the following transparency features of DistributedDatabase and give an example each. Failure transparency Locationtransparency Replicationtransparency 4. Concurrency transparency

What command in DDL do you use to create the database structure and tables, and what DML command do you use to populate the data into the table you built?

I want an opening line that why should i be awarded High Distionction grade in database. What should i write. (I completed all tasks for high distinction)

two users are trying to gain an access to a lockable entity in the DBMS and person A is granted the lock. How does the database handle person's B request? What options could occur?

explain the primary job responsibilities required of a DBA. Also the difference between a data administrator and a database administrator.?

What are the advantages and disadvantages of SQL? Discuss and demonstrate the basic mechanisms for accessing relational databases from various types of applications. Please provide examples as part of your explanation.

Discuss the evolution of file system data processing and how it is helpful to the understanding of the data access limitations that databases attempt to overcome. Also, include your understanding of data and information.

In Ken's Travel database, the Reservations table and the Customers table have a common field by which they can be joined and queried. What type of constraint will ensure the consistency of data between these tables?

What are three forms of database connectivity methods that can be used as an interface between applications. An example that demonstrates how each could facilitate data exchange functionality in a cloud service environment. CIS Strategic planning for Database System

Below figure shows the ER diagram that captures important information about customers, supplier and orders in car parts business. Convert the ER diagram into a relational database schema. Be certain to indicate primary keys Eg. Suppliers (SupplierID:Number(PK); Supp_contact: Number) b. Briefly describe the term "Bridging

Data model for Customer and Car parts Customer ID Name Contact OrderID Date StaffID Deepani March 13, 2019 Suppliers SupplierID SuppContact Orders PartID Parts Partdescription

There are many third-party reporting tool such as Power BI that run against data warehouse so that it does impact OLTP database. Some of the benefits of data warehouse are: that data from multiple systems can be combined to provide a consistent view of information for the company that it allows storage of data in one database by transforming data

Create a database schema for a dental clinic. The dental clinic has five relations, Patients, Doctors, staff, Appointments, Payments. You are free to choose the attributes for each relation, and you are required to show the Primary keys. ?

Let's say I have the following attributes: salesperson, date of sale, region, total sales, and commission rate. What does multidimensionality mean for reporting capabilities? How would that compare to reporting on these fields in a relational database?

1-Explain why the impact of failure is greater in database processing, compared with the nondatabase approach. 2-Concerning the Logical Database Design Process, discuss why we should not list or store multiple pieces of data ( repeating groups ) in the same field in our tables. 3-The basic relationships are one-to-many, many-to-many, and

What are some industry standard methods for backing up your MySQL database? Can you provide a specific backup script that can be used and explain what options are enabled?

Task 2 total marks 48 Inside the document named there are 3 questions 1. Explain the ways in which normalisation can mitigate data quality issues in relational databases. 16 Marks 2. Describe, using an example, the steps involved in creating a Java program that can retrieve data from a relational database such as SQLite. 16 Marks 3. Compare the

Q1:- Removing suggested medicine ofa patient record from a hospital database could remove all details of the particular patient from the database such as the room_no, doctor,disease, bed_No , location etc.Which kind of anomaly it is. Q2:- In the University classes are scheduled according to courses,teachers, students, classrooms and labs. Create

QUESTION 4 (10 MARKS) The following tables for part of a database held in a relational DBMS (Primary Key, Foreign Key) CUSTOMER (CustID. CustName. Annual Revenue) TRUCK CITY SHIPMENT (TruckNumber, DriverName) wwwwwww (CityName, Population) wwwwww wwwwwwwwww wwwwwwww wwwwwwww (Shipment Number, CustID, Weight, Year, TruckNumber, CityName) Formulate

A1 Armstrong Axioms a. Consider the relation R(L,M,N,O,P,Q) and a set of functional dependencies F LNOM, MNLOP, NO, OPLN. 2pt Can we infer NP LM from F Show your work 3pt Can we infer NQ LO from F Show your work b. 10pt Consider R (O,P,Q,R,S,T) to be a relation schema, and let F O P, QO, PR Q, RS T be a set of functional dependencies (FDs).

Elaborate following with examples Explain the importance of data to a company Discuss the problems resulting from ineffective data management. Factors that influence the growth of data. Describe the functions and skills of DA and DBA. Differentiate the roles of DA and DBA.

Draw the ER-Diagram for the following database schema. Specify the types of relationships in details on the diagram. Customers { Customer_ID , C_Name} Employees { Employee_ID , E_Name} Orders { Order_No, Customer_ID , Employee_ID, } Order_Details { Order_No , Product_No } Products { Product_NO , Product_Name}

A particular 512GB hard drive has 2048 cylinders and 4 platters. If the worstcase seek time is 24ms (0.024 seconds) and its rotational speed is 7200 rpm, what is the access time to move from track 1, sector 1 to track 256, sector 32,768 To receive full credit, show the computation of each part of access time. For the toolbar, press ALTF10 (PC) or

Q1 What is the run time of the following function def f1(number) rc 1 for i in range(0, 5) rc 1 return rc

Question 1 Study the scenario and complete the question(s) that follow 20 Marks Setting Up Oracle SQL Developer is Oracles free application for accessing and working with Oracle databases. This application is called an integrated development environment (IDE). Its a type of application that lets developers work with code. To set up Oracle SQL in

2. Identify the people who need training on the new system. For each group, describe the type of training you would recommend and list the topics you would cover.

what is the correct ERD diagram of this scenario? "A student project is required to create a small relational database about Mobile ownership in a school and all the APPs for the phones Every student in the school own at least one phone and some students own several phonesEach phone runs at least one APP but some APPs listed in the database do not

1. Create a MySQL database to store the registration data about your customers as well as a login, password, and two security questions for each customer. 2. Implement your design in MySQL, using any combination of phpMyAdmin and the commandline interface, but try to use both enough to enhance your familiarity with each. Provide screenshots to

Distributed Databases Please short andfocused answers: Discuss two examples of transparency in databases How does three-phase commit differ from two-phase commit? How does horizontal fragmentation differ from vertical fragmentation?

What does the following function call do to this object What does the function return thelist.makeset(pony) thelist front back

Database schema below shows the relations involved in Maju Holdings system. PARTICIPANTS EVENTS ATTENDANCE STAFFS LOCATIONS TASKS (PARTID, PARTNAME, PARTPHONE, PARTEMAIL, PARTADDRESS, PARTJOB) (EVENTID, EVENTNAME, EVENTBUDGET, EVENTHEME) (ATTID, ATTDATE, EVENTID, PARTID) (STAFFID, STAFFNAME, STAFFADDRESS, STAFFPHONE, STAFFEMAIL, STAFFPOSITION,

Consider a discrete time ACC system with 1s sampling period with A.B5.C. ,D0, K 11, i.e. the closedloop statetransition matrix is (A BK). The following LHA represents above system. Find out Post 12 (x 10, v 5) i.e. the regionpoint for the given initial regionpoint after the application of the Post operation 12 times on the given LHA (up to 3

For each of the following problems, show a conceptual data model (entity relationship diagram), consisting of object sets, relationships, attributes and so on, that can be used to answer questions similar to the questions given. Indicate the cardinalities and participation constraints: Assume these models are for a university environment. a) How

Optimizing Queries and Tuning SQL Server For this Lab you will use the default instance of SQL Server that you installed during Lab 1. Partial answers or answers that are partially correct will result in minimal partial credit. 1. Run the SQL Script Included with this Lab specification (the Microsoft Recursive CTE example) and show me the

a)Database Design phase is the second phase of the Database Life Cycle (DBLC) that focuses on the design of the database model. It consists of three essential stages which are conceptual design, logical design and physical design. Briefly explain the differences among these stages and identify either they are softwaredependent or not. (8 marks)

Q6 The following show a table of keys and the hash index of these keys within a table of size 10 hashldx key alpha 8 beta 9 gamma 8 apple 4 orange 4 cherry 5 part a Draw an empty array of size 10 that represents a linear probing table. part b Insert the keys in the following order and show the final array beta alpha gamma apple cherry orange part

PART A (10 MARKS) As a database designer, you need to develop a clean eating diet plan database system based on the following requirements 1. Open Microsoft Access and create a blank Access database. Save as YourFullNameStudentIDClean Diet DatabaseSystem ANSWER (2 marks) Paste your screenshot of database here 2. Create tables as listed below and

Use SQL Developer to create the My Guitar Shop database, to review the tables in this database, and to enter SQL statements and run them against this database. Use SQL Developer to create the My Guitar Shop database 1. Start SQL Developer. 2. Connect as systemsystem. 3. Open the script file named createmgsuser.sql from Blackboard MGS folder. 4.

Relational algebra operators Duplicate elimination 5 Union u Difference Rename p Sorting T Left outer join Cartesian product x Groupingaggregation y Intersection n Projection TT Join Selection,Given the following query, write the Relational Algebra operator tree equivalent. SELECT U.id, U.name FROM LibUser AS U LEFT OUTER JOIN Checkout AS C ON

A high school wishes to develop a database to manage the marks for their learners in Grade 8 through to Grade 12. Each teacher takes one or more subjects, however, no more than one teacher teaches one subject. Each learner studies six subjects per grade, and has to complete one or two homework assignments for each subject and write a test for

e) Find the book name which is total order is more than 3. (4 marks),QUESTION 4 Consider the following relational database PUBLISHER (PublisherName, City, State, Country, PhoneNum) AUTHOR (AuthorNum, AuthorName) BOOK (ISBN, BookName, Publication Year, AuthorNum, PublisherName) CUSTOMER (CustNum, CustName, Street, City, State, Country, Email) ORDER

The relational schema of the database, which is about the Library Management System, is provided below BOOK BookID, Title, Author, Publisher, PublishDate, ISBN, Category, Language, TotalCopies, AvailableCopies BORROWING BorrowingID, BookID, MemberID, BorrowDate, ReturnDate, FineAmount MEMBER MemberID, Name, Address, Phone Number, Email,

Suppose you have to design a database of the university where the university has different departments and departments have different programs in different program different subjects are Offord that are taught by the teachers. Design database schema by finding entities and attributes then creates ERD.