Databases Questions and Answers July 06, 2018

Could the "Select" command be considered a data manipulation language (DML)? Explain, include bibliographic references

DATABASE: SQL Data Manipulation Language (DML) : Insert, Update & Delete Statements What are the Command to insert, update and delete data within the database tables please explain?

Table Student Attribute Content Data Type Nullable Default Unique Check Constraint FK Referenced Table StudID (PK) StudName Students id Students name CHAR (10) No VARCHAR No (50) Stud Gender Students gender CHAR(1) No StudIC Stud Faculty Students IC Students faculty CHAR(14) VARCHAR 22 No No (10) StudSession Stud Year StudPhoneNo Students session

What are the 3 capabilities a database management system must have? Select ONE from our text and describe it .... What does this capability provide? The text shows data definition language, data dictionary and data manipulation language. I believe this is what I am looking for.

Define each of the following terms: a. base table b. data definition language c. data manipulation language d. dynamic view e. materialized view f. referential integrity constraint g. relational DBMS (RDBMS) h. schema i. virtual table

What is relational algebra? b) What are the types of relational algebra? Question No. 02 a) What is Data definition language (DDL)? b) What is Data manipulation language (DML)? Question No. 03 a) Differentiate inner and outer join. b) What is full outer join?

Discuss a situation where a database administrator or application developer would use a trigger instead of a constraint. Use a data manipulation language (DML) trigger example and explain the situation and trigger type. Justify your answer with a link to the article(s) used for reference.

What are NoSQL databases, and how are businesses implementing these types of database systems?

Explain what are the key capabilities of NoSQL can do?

Discuss why NoSQL databases have gained huge popularity in recent years.

Compare a traditional database, with an analytical database, and a NoSQL database Please write references

How is NoSQL, newSQL help improve our daily activity? How will noSQL and/or new SQL help with future technology How is big data security work? How is big data security apply to our daily activity and in the future What are the benefits of Data Clelaning and Integration? How does it help our activity and how it going to work with future technology

Compare and list the Data modeling difference between a relational database and NoSQL MongoDB ?

in term of NoSQL MongoDB : what are the Emerging Technologies Over the Horizon ?

Outline four potential solutions for SiteWit Corp's challenge of adopting NoSQL technology. These options include taking no action, proceeding cautiously through limited experiments, developing a new product using NoSQL technology independently or through a partnership, or taking a bold leap of faith. Which of them might you consider the best for

When is it more appropriate to use a NoSQL database instead of a relational database

Describe how NoSQL can improve web server security ?

Give your opinion, whether you agree or not. Why would you perform a silent installation? A silent installation is exactly how it sounds, an installation that does not need any interaction from the user. This allows the function to be performed without user interference and also by eliminating the need of the user, you can ensure that each

Please write down the Relational Data Model for the following ER Model

2. Please write down the Relational Data Model for the following ER Model (2 pts). Dep DeptNo DeptName DeptFloor Deptphone Manage Emp EmpNo empfname empiname position sex DOB salary Belongs To

Subject is Database Programming not object-oriented. Didn't have anymore options) Example: Your company has traditionally used ER models for representing data for a large food company client due to the complexity of the data. The food company monitors data from over 1,000 retailer locations. Would this be Object-oriented model? Relational model?

how data redundancy is handled in the relational database model?

DRAW A RELATIONAL DATA MODEL FOR INSURANCE OF A CAR AND Construct appropriate tables by specifying the integrity constraints.

DriverID Address Name Person Owna License Model Year Car Participated Damage Amount Location Report Number Accident Date

The relational data model: What is a null value? What gives rise to null values in a relation?

Discuss some limitations in the relational database model.Discuss the benefits of encapsulation.Discuss what an object/relational database is.?

Which component in Relational Leadership Model is the most critical in your opinion?

Discuss the importance of data models. What is a business rule, and what is its purpose in data modeling? How do you translate business rules into data model components? Describe the basic features of the relational data model and discuss their importance to the end user and the designer. Explain how the entity relationship (ER) model helped

describe the importance of relational data model or entity relationship model.

Describe a database, a database management system, and the relational database model.

Convert the following ER diagram into a Relational Data Model Diagram

SupID SuperFirstName SuperLastName NumContracts SuperName NumOfStocks SUPERVISOR NumOfHrsWrkdAsAdminHelper Assigns CName NumOfYearsWithCompany, Consultant CID Skills Supervises Assigns ContractID ConStartDate PMID CONTRACTS Manages Project Manager Has StartDate Customer CustFirstName CustName CustLastName CustID PhoneNumber PMName

CASE STUDY Flywell, an Airline company, recently experienced an SQL injection attack. The attack exploited a vulnerability in the web application that allow users to connect to its Oracle Database. The SQL injection was embedded in the web URL which triggered the dynamic SQL statements in the website HTML to send a request to the database for

The Oracle DBMS is used as an example many times throughout the text. Use the Internet to find at least three resources that you think would be helpful to an Oracle Database Administrator in his/her work of managing an Oracle DBMS. Provide the name of the resource, the author, and a brief description about the site. In addition, provide some

Use Oracle SQL DATABASE

UNNORMALIZED TABLE 1. MOVIE ID MOVIE TITLE MOVIE VALUE MOVIE QTY MOVIE CAT ID MOVIE CATEGORY 1 Alien 10 5 1 SciFi 2 Bladerunner 8 3 1 SciFi 3 Star Wars 15 11 1 SciFi 4 Texas Chainsaw Masacre 7 2 2 Horror 5 Jaws 6 The good, the bad and the ugly 7 Silverado N N N 7 1 2 Horror 7 2 3 Western 7 1 3 Western 8 Duck Soup 5 1 4 Comedy 9 Planes, trains and

Please list several similarities and differences about the characteristics of each of the five relational database vendors. https://www.microsoft.com/en-us/sql-server/sql-server-2019 https://www.oracle.com/database/technologies/

Write a query to display month number, month name, and average sales amount for months with the average sales amount greater than average sales amount in 2017. Round the average amount to two decimal places. Sort the result by the month number. The query returns 5 rows. Include both the query and the result in your answer. See the output columns

Discussion: Migrating to a New Sales System Your original company's database was created using MS SQL. Your company merged with another company that used an Oracle database. An enterprise view of all the informationboth current and futureis needed. Here are some of the concerns: Accurate data availability Duplication of reports Consistency

Ms. Gomez looked at the ER diagram and built the database using Oracle. What type of database user is she?

PatientGender) Drug to Take NotToTakeWit Drug Not Allowed with Drug to Take DrugID Dosage IngID Ing Name DrugCoating Type DrugName PatientID DRUG Contains Quantity Includes (Patient Name (PatientName PATIENT Receives PatientFName) PatientAge (PatientBDate DRUGINTAKE EVENT DIENumber DIEDate DIETime Administers INGREDIENT NurseName NURSE NurseID

Your client wants to move to open source database on cloud, what is your recommendation and why ? Your organization has average volume of transactions and workloads, and they want balance between the perfomance and the price, which disk type you will choose when you deploy your VM and Why ?

"The Oracle Database Security Assessment Tool is a stand-alone command line tool that accelerates the assessment and regulatory compliance process by collecting relevant types of configuration information from the database and evaluating the current security state to provide recommendations on how to mitigate the identified risks." In view of the

Assume there is a critical .NET web-based application that resides on three IIS servers, sits behind a load balancer, utilizes an Oracle database for its application data and stores its session state in a SQL Server database. You get a call that this application is suddenly performing very poorly for at least some users. Provide five distinctly

Data are availability, integrity, security, backup, and recovery. Discuss this statement, from the initial concept of a database. Discuss solutions available, with an Oracle database in mind. b)Explain the difference between static data and transactional data and outline the issues that need to be considered when storing such data. c)What is meant

Describe how the Operations Are Carried Out - Facility Selection/Design on the database company Oracle. 2. Describe How Operations Are Organized - Degree of Automation for the database company oracle

PLEASE SHARE YOUR OPINION WITH REFERENCES YOU USE (NEWER THAN 2018) WITH CITATION. Y Maruti Suzuki is an industry leader in India's fast growing passenger car market. Over the years, Maruti Suzuki has built its IT infrastructure on various Oracle databases and technologies including Oracle Real Application Clusters, Oracle Fusion Middleware

what are the examples of databases? And why is oracle the most important database to people?

Evaluate different backup strategies and types. Explain the phases of a database instance startup. Explain the steps to back up and recover a database in Oracle 11g Express. Explain the steps to back up and recover a database in Oracle 12c.

Create a database using professional principles and standards. Use a relational database software application to develop a database implementing the logical design into a physical design. Use an Oracle database to create the normalized physical database including tables, columns with data types, primary keys, constraints, etc. Create a minimum of

Artist ARTISTID INT PK Name Amount Address Phone Art ARTID INT PK Cost Date Size Genre LOCATIONID INT FK ARTISTID INT FK Location LOCATIONID INT PK Area Location

I need help with this: The following assignment is based on the database environment designed in the Week Three Individual Assignment. Your database project must meet the following assessment requirements: Create a database using professional principles and standards. Use a relational database software application to develop a database

PK Customers. CustomerID CustomerName PK HO Customer Address CustomerTelephone PRODUCT Item ID ItemGenre Item Value item Name UPCNumber EMPLOYEE O OH PK EmployeeID PK EmployeeName STORE PAYMENT PK PaymentID FK 1 Item ID FK 2 EmployeeID Date dateTime Payment details TotalSum StoreID Store Loc

Your organization decided to migrate from Oracle Database to Single server PostgreSQL on Azure, what is migration method that you will apply and why ?

Identify and share with your classmates: T-SQL injection warnings or tips found on the Microsoft Web site or elsewhere online that are specific to Microsoft SQL Server, OR PL/SQL injection warnings or tips found on the Oracle Web site or elsewhere online that are specific to Oracle Database, OR SQL injection warnings or tips found on the MySQL Web

A hospital uses an application that stores patient X-ray data in the form of large binary objects in an Oracle database. The application is hosted on a UNIX server, and the hospital staff accesses the X-ray records through a Gigabit Ethernet backbone. Storage array provides storage to the UNIX server, which has 6 terabytes of usable capacity. a)

Maruti Suzuki Drives Business Growth on a Full Oracle Stack Youtube video: In regards to Business Intelligence effects on Maruti Suzuki, answer the following questions: 1.) What were the business challenges facing Maruti Suzuki management prior to adopting the Oracle suite? 2.) What advantages does Maruti Suzuki derive from working with a

I need to answer this question you created a database for your small retail store. Though business has been good, you decide to merge your company with another small store to lower prices and increase sales. Your original companys database was created using MySQL. The company you merged with stores their data in an Oracle database. An enterprise

Database operations such as shutting down or starting up the database should not be performed by non-administrative database users. These operations require SYSDBA or SYSOPER privileges. For our discussion please consider and expand on the following questions: 1) Discuss how users can be authenticated by the operating system to connect to the

Suppose you have the following table in SQL Server: VENDOR_STORE (VendorID, VendorName, VendorPhone, StoreID, StoreName) And you wish to transform this table into two tables as follows: VENDOR ( VendorID , VendorName, VendorPhone) STORE ( StoreID , StoreName, VendorID ) Write the SQL statements needed for filling the VENTOR and STORE tables with

In this assignment, will start to Build/Implement your Database in MS SQL Server.. Based on the ERD: CREATE all tables INSERT data - add at least 10 records for each table TEST the implementation - Write SQL statements to test the implementation Tasks : Review the resources below to complete this assignment. You have five tasks: **** Upload

Employee EmployeeID (PK) EmployeeName Role Contact Number Employment History Store Store ID (PK) Store Name Location Contact Number Inventory InventoryID (PK) Quantity Customer CustomerID (PK) CustomerName Customer Number Purchase History Transaction TransactionID (PK) Transactiondate Payment Method Total Amount Product ProductID (PK) Product Name

I need an executive summary for the following below in paragraph form: Integration of Microsoft Dynamics and Net Suite into SQL Server for American Enterprises, Inc American Enterprises, Inc is company that wants to do this integration. And they are browsing for proposals. Vision: American Enterprise, Inc had a latest acquisition to increase its

For SQL Server what login type do you prefer? Window or SQL Server authentication? Why? Provide a brief explanation? Assume you have access to Window Active Directory Service

Briefly explain SQL Server replication and HA cluster? Please don't forget to include different replication options (types of replications) available to you as a DBA. What are some differences between these two SQL Server products?

Looking forward to current and future needs in your own industry or one in which you desire to work, describe how the more advanced SQL server integration services (SSIS) data migration software, SQL server analysis services (SSAS) online analytical processing technology, or SQL server reporting services (SSRS) report software could be useful for

SQL Server Implementation Proposal Recently, Shiv Corp, a solar panel manufacturing business, put out a bid for database system due to their rapid growth. Congratulations! Your company was chosen from many to develop and implement a proposal for implementation of SQL Server. Shiv Corp uses MySQL for their order placement system. There are various

We notice that you have some experience with SQL Server 2014 DBMS. How would go about creating a SQL Server maintenance job? (provide a summary of the process) What are some of the steps in the maintenance plan ?

NO. 2 What are the different types of TCL available

Draw the Entity Relationship Diagram (ERD) with the labels.

BUSINESS CASE STUDY 5 CAR RENTAL MANAGEMENT SYSTEM Diamond Car Rental wants to expand its business and venture into the car rental industry. To streamline operations and enhance the customer experience, the company plans to create a car rental management database. The database will store customer details, including customer ID, name, address,

Base on the case study, determine whether is entity relationship diagram erd or enhanced entity relationship diagram eerd and draw complete flowchart diagram. example of answer:

Case Study An online system for AK Solutions and Services (AKSS) A relational database is to be designed for this company Ak Solutions and Services (AKSS). It is a medium sized company dealing with applications of computers and services. The Company delivers various products to its customers ranging from a single application program, customized

What is the difference between a conceptual, a logical, and a physical data model? Where do relationship diagrams (RDs) and entity/relationship diagrams (ERDs) fit in?

Based on given scenario, I am required to design an entity relationship diagram (ERD)

A school decides to develop a computer application to facilitate storage and retrieval of relevant information of its athletic meets including Contestant name, class (e.g. 1D), grade (e.g. A, B, C), sex, house Eventgrade, sex, game (e.g. 200m sprint, shot put, 4x100 relay), type (e.g. heat, semifinal, final) Athletic events are classified into

provide an Entity Relationship Diagram (ERD) based on the data below:

A B 1 Dataset Chicago Public Schools Progress Report Cards C D E FL 2 Field name 3 School ID Field name in database Data type Description Required NULL value al School ID integer School unique ID yes no 4 Name of school 5 street Add Schoolname string name of the school yes no streetadd string location of the school yes no 6 city 7 zip code 8

What is the importance of Entity Relationship Diagram (ERD) in designing an Information Systems?

Draw the Entity Relationship Diagram (ERD) An archeological museum.

Propose a Design using an Entity Relationships Diagram (ERD) please.

You are the CIO of the newly established Data Mining, Inc. (DMI), a company that specializes in collecting, storing and analyzing data on customers purchasing habits and then selling its findings to large ebusiness vendors. First, here is some background on the company, DMI was conceived by the CEO of a major corporation, MountainTops.com, Inc.,

DATABASE DESIGN AND ER MODELING Describe: Entity-Relationship Modeling Database Modeling Entity-Relationship Diagram (ERD) add references

Physical entity relationships diagram ERD, shows entities/ attributes/ keys identified. And relations ship between entities/ and the cardinality.

Art Gallery Management Database Project A local art gallery has approached your team to help them set up their database. To simplify things for this project, lets assume the new database must only keep track of the following A record of each artist name, birthplace, age, style of art A record of each art piece name of the piece, year it was

Entity- Relationship Diagram (ERD), explain its purpose and the information presented below including number of tables, relationships titles and types.

Draw a bi-directional Entity-Relationship Diagram (ERD) for the following scenario with the software EdrawMax using the Crows Foot symbols. Scenario:One or many Systems Programmers develop one or many Systems. One or many systems are developed by one or many Systems Programmers. q2: Draw a bi-directional Entity-Relationship Diagram (ERD) for the

Entity Relationship Diagram (ERD) below to be created using Crow's Foot notation.

What are entity relationship diagrams (ERDs) important in database design, even in smaller databases?

translate the corresponding class diagram into an entity-relationship diagram (ERD).

What are the three key parts of an entity-relationship diagram (ERD)? Please, briefly explain each part.

A database design has design an Entity Relationship Diagram (ERD) for a College at Parit Raja. The staffs are lecturer who need to do research and supervising student. The students need to register subject course and attend the course schedule. Without adding new attributes, redraw a complete Entity Relationship Diagram (ERD) with identify keys

What are similarities and differences between a Data Flow Diagram (DFD) and an Entity-Relationship Diagram (ERD)? and what are reasons why you would choose one approach over the other?

Program for Calculate Compound Interest when principal, rate and number of periods are given.

Explain briefly the data processing instructions for ARM processor .

Draw the pipleline timing diagram of: A) 2-stage pipeline with an example of a processor B) 3-stage pipeline with an example of a processor C) 5-stage pipeline with an example of a processor

21. (a) A small project consists of seven activities for which the relevant data are given below. Activity A Preceding activity Activity duration in weeks 4 B 7 C 6 D A, B 5 E A, B 7 F C, D, E G C, D, E 6 5 5 (i) Draw a network for the above project (ii) Find the completion time for the project. (b) Use the data in the table below to draw a PERT

Discuss the FOUR methods that The ANSITIAEIA Standard identifies for distributing interbuilding backbone cables to multiple buildings on campus. Discuss communication media available in the industry today. Discuss any FOUR differences between Connection oriented and Connectionless service

Use entity Relation diagram to illustrate a recursive relationship. Discuss the three quality of a Candidate Key to be selected as primary key. Read the following case and answer Question that follows. A Company is organized into departments Each dept. has a unique number, unique Name and a particular employee that manages it. We keep track of the

A small project consists of seven activities for which the relevant data are given below. Activity A Preceding activity Activity duration in weeks 4 B 7 C D A, B E A, B F C, D, E G C, D, E 6 5 7 6 5 Draw a network for the above project Find the completion time for the project. Use the data in the table below to draw a PERT network diagram.

1. Describe the following terms in the context of Information Systems. (a) Socialtechnical system. (b) Decision making. (c) Business Process Reengineering. (d) egovernment. (e) Information System Software Project Management 2. (a) Distinguish a DSS from a MIS. (b) Explain how they provide value to a business. (c) Define a Group Decision Support

1. (a) Define a Geographic Information System and explain how it supports decision making. (b) Describe the three characteristics of a digital firm. (c) Outline the five steps in an ethical analysis. (d) Define the term risk assessment in relation to information systems and explain how it is conducted. 2. (a) Define the term Business Process

7. (a) Identify three major risk factors in information systems projects. (6 mks) (b) Explain why builders of new I. Systems need to address implementation and change management. (6 mks) (c) Explain why eliciting support of management and end users is so essential for successful implementation of information systems projects. (8 mks) 8. (a)

11. (a) Explain how information systems serve the various levels of management in a business. (b) Explain four ways in which a MIS improves organizational performance. 12. (a) Describe the major characteristics of TPS, MIS, DSS, and ESS. (b) Describe the relationships amongst TPS, MIS, DSS, and ESS. 13. (a) Outline six principles which can be used

15. Describe the role of the following in promoting information system security. (a) Firewall (b) Antivirus software (c) Digital certificates (d) Data encryption 16. (a) If you were developing a business continuity plan for your company, where would you start What aspects of the business would the plan address (b) Explain the different types of

18. (a) Explain how ESSS help senior managers make better decisions. (6 mks) (b) Describe the capabilities of an ESS. (4 mks) (c) Describe three basic components of a Decision Support System (DSS). (d) Explain the role of info systems in helping people working in a group make decisions more efficiently. (4 mks) (6 mks) 19. (a) Describe the groups

(a) Develop a network diagram from the following project development schedule. (b) Determine the critical path and the project duration. (c) Explain the role of ICT in achieving Millennium Development Goals (MDGs) and Vision 2030.

Activity A Preceding activity Activity duration in weeks 3 B 1 C 5 D A 1 E C 6 F E 1 G H B, D, F G 2 8

(a) Multi Field Connections is a high technology retailer and mail order business. In order to improve the processes, the company decides to install a new microcomputer system to manage entire operations i.e. payroll, accounts and inventory. Terminals at each of its many stores will be networked for fast dependable service. The specific activities

B C A D B Activity Building insulated enclosure Decide on computer system Electrical wiring of room Order and collect computer Symbol Preceding activity Time estimate (weeks) Increased staff A 4 1 1 3 3 2 2 1 Install air conditioner Install computers Staff selection E A 4 2 F D, E 2 2 G B 5 1 Install software Staff training H C, F 2 1 I G,H 3 1

22. (a) List six stage process that you can use to manage changes as a project manager. (b) As a project manager, you should ensure that your project is a success. Describe any four factors that you would put into place to achieve this. (6 mks) (8 mks) (c) Planning is a vital aspect in project management. Outline the five steps of project planning

27. (a) Define the term, information systems planning. (b) State four benefits of I. S. planning. (c) Describe the information systems planning process. (d) Explain the term, information system project management. (e) Differentiate between business automation and business reengineering. 28. (a) Use the data in the table below to draw a network

40. (a) Why is it essential to make periodic reviews of information systems projects (b) Explain four characteristics of a welldesigned information system. (c) Briefly explain the three fundamental components of an expert system. 41. (a) Explain the term Decision Support System. (b) Explain four characteristics of a Decision Support System. (c)

37. (a) An important aspect of information systems planning is that an organizations strategic plan is the basis for the formulation of the information systems strategic plan. State and explain the contents of an information systems strategic plan. (b) Identify and explain four types of system maintenance. 38. (a) Define the term, system. (12 mks)

31. (a) Explain the role of an I. S. in offering competitive advantage to an organization. (b) Outline the steps of I. S. acquisition. (c) Identify five symptoms of a failing project. (d) Identify four control measures andor techniques of rescuing a failing information system project. 32. Study the project schedule represented in the table below.

43. (a) State two main features of each of the following systems. (i) Management Information System (MIS) (ii) Office Automation System (OAS) (iii) Transaction Processing System (TPS) (2 mks) (2 mks) (2 mks) (b) Outline four major components of an information systems project plan. (4 mks) (c) Explain the use of the following techniques in project

50. It is conventionally assumed that there are three levels in the organisation at which decision making takes place. a) Identify and define each of the three levels. (6 mks) b) Describe the characteristics of decision making at the different levels. (6 mks) c) Give an example, for each level, of the type of assistance or information a