database - 4793 Words

Question 1 5 of 5 points An alternative to combining tables by a subquery is to use a join. Selected Answer: True Question 2 5 of 5 points Regarding the interchangeability of subqueries and joins, Selected Answer: a join can sometimes be used as an alternative to a subquery, and a subquery can sometimes be used as an alternative to a join. Question 3 5 of 5 points When making an SQL query, we are using SQL as a(n) ________. Selected Answer: DML Question 4 0 of 5 points Every subquery can be alternatively expressed by a join. Selected Answer: False Question 5 5 of 5 points The clause SELECT COUNT (*) results in a table with a†¦show more content†¦Question 2 5 of 5 points The SQL keyword UNIQUE is used to define alternative keys. Selected Answer: True Question 3 0 of 5 points If a trigger is being written to enforce referential integrity actions, you cannot use an INSTEAD OF trigger. Selected Answer: False Question 4 5 of 5 points If the values in an SQL view are changeable through the view itself, which SQL statement is used to change the values? Selected Answer: UPDATE Question 5 5 of 5 points In representing a 1:N relationship in a relational database design, the key of the table representing the entity on the many side is placed as a foreign key in the table representing the entity on the one side of the relationship. Selected Answer: False Question 6 0 of 5 points When transforming supertype/subtype entities into a relational database design, an entity is created for the supertype only. Selected Answer: True Question 7 5 of 5 points Cascading deletions are generally not used with relationships between strong entities. Selected Answer: True Question 8 5 of 5 points An ID-dependent table can be used to represent multivalued attributes. Selected Answer: True Question 9 5 of 5 points The key of an intersection table is always the combination of the keys of both parents. SelectedShow MoreRelatedDatabase And Database Management System Essay1068 Words   |  5 PagesZalgaonkir Pearson Cape Town Campus Introduction to Databases project Student Number: MB2014-0413 Teacher: Andrew Davies Due Date: 23/09/2016 2 Contents Page Page 1†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦..Cover Page Page 2†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Contents Page Page 3-5†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦.Question 1 Page 6-12†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Optional Access Screenshots Page 13-18†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦.Question 2 Page 19†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦References and Bibliography 3 Question 1 1.1) Database Database is defined as a set of related data in many tables andRead MoreRelational Database : A Database1622 Words   |  7 Pages Relational Database Introduction – What is a relational database It is a database which shows the links and relationships between two sets of data/stored information in a document or mainly entities. This means e.g. if a computer system has to store a lot of data/information about people instead of repeating the same row of information which may include personal or unnecessary things, you will then be able to click on the main primary key data which then leads to the actual personal things. ThisRead MoreDatabase Security And Concerns Of A Compromised Database894 Words   |  4 PagesDatabase Security and Concerns In today’s world, there is a growing amount of complexity when it comes to databases. With that growing complexity, an increasing amount of security concerns arise, such as: unauthorized access and SQL injection. SQL injection is used to attack data-driven applications. SQL injections can manipulate or destroy databases depending on its purpose. Due to the security breaches, measures are constantly put in place in order to prevent anymore from happening. This paper’sRead MoreQuestions On Database Security And Database Systems1368 Words   |  6 PagesDATABASE SECURITY Submitted to the Faculty of American Public University By Loren Robert Hensley In Partial Fulfillment of the Requirements for the Course of INFO620 Enterprise Database Systems November 2014 American Public University Charles Town, WV â€Æ' Abstract This paper explores the different aspects of security as it pertains to database systems. It will provide an overview of security concerns such as access control, user authentication, reliability and data integrity, as well as how IT professionalsRead MoreDatabase Indexes : Database Index2068 Words   |  9 Pages Database Indexes Akhila Mupparaju Wilmington University IST-7000 April 23, 2015 Sten David. Database Indexes A Database, support query optimization technique (Jeffery A. Hoffer, V. Ramesh, Heikki Topi, 2010). An index is a pointer to the data in a table, and it is an access mechanism that helps to find out where a record present. A database can have one or more indexes connected with it. A database index is one type of data structure, it is usedRead MoreTypes Of Database For Flat File Database939 Words   |  4 PagesTypes of Database 1. Flat File Database A flat file database is an excellent way of storing a pretty small amount of records. Flat file can be a plain text file. Flat file are generally not a structural relationships between the records. For example a spread sheet application such as Excel can be used as a flat file database. Each row in a worksheet can be a record and each column and a field. Flat file database can also be stored in a dedicated database application such as Access. Installing databaseRead MoreDatabase Management System : History Database System1408 Words   |  6 PagesDATABASE MANAGEMENT SYSTEM History of database system: Brief history of database management is as follows, 1950s: Database management system started its journey in late 1950s with the invent of magnetic tapes. All the data was stored in tapes. Processing of data requires reading data from one or more tapes and writing to a new tape after processing. 1960s – 1970s: Database management system could enhance its features with invent of harddisk. Unlike files, hard disk supports random accessRead MoreTechnical Guide : Database And Database Essay1551 Words   |  7 PagesTechnical guide Database It is the collection of schemas, tables, queries, reports, views, and other objects. The data are typically organized to model aspects of reality in a way that supports processes requiring information, such as modelling the availability of rooms in hotels in a way that supports finding a hotel with vacancies. It is a structured set of data held in a computer, especially one that is accessible in various ways. A database is a collection of information that is organized soRead MoreRelational Databases4819 Words   |  20 PagesCHAPTER 4 RELATIONAL DATABASES SUGGESTED ANSWERS TO DISCUSSION QUESTIONS 4.1 Contrast the logical and the physical view of data and discuss why separate views are necessary in database applications. Describe which perspective is most useful for each of the following employees: a programmer, a manager, and an internal auditor. How will understanding logical data structures assist you when designing and using database systems?lt;/paragt;lt;/questiongt;lt;questionRead MoreRelational Database : Assignment : Database1882 Words   |  8 PagesRelational Database – Assignment Introduction – What is a relational database It is a database which shows the links and relationships between two sets of data/stored information in a document or mainly entities. This means e.g. if a computer system has to store a lot of data/information about people instead of repeating the same row of information which may include personal or unnecessary things, you will then be able to click on the main primary key data which then leads to the actual personal