Your company is concerned there is a problem with the design of some of the database tables. They want you to look at the tables and determine if there is a problem. Management is concerned about data anomalies and data redundancies. They have stressed it is important to have correct design as it is used for making decisions and used as a basis for reports in the various departments. Examine the fields in each table and determine if the table is designed correctly or incorrectly. Select the dropdown that is appropriate for each table. Student STUDENT_ID STUDENT_NAME ADVISOR | ADVISOR_OFFICE DORM DORM ADDRESS 021345 | Melissa, Tandy Snow Peaceful 145 Mountain 123 Peace Ln. Hall Hall 035678 Cindy Lou, Mary 324 Flower Hall Tulip Hall 789 Tulip Ln. Hardie 45678 Clayton Harvey Snow 145 Mountain Bee Hall 45 Bee Ln. Hall 27869 | William, Zander Harvey 145 Mountain Peaceful 123 Peace Ln. Hall Hall Advisor ADVISOR_LNAME ADVISOR_PHONE ADVISOR_EMAIL ADVISOR_ID ADVISOR_FNAME ADVISOR_LNAME ADVISOR_OFFICE ADVISOR_PHONE ADVISOR_EMAIL 1023 Melissa Snow 145 Mountain Hall 775.345.9045 msnow@gmail.com 3698 Cindy Lou Harris 324 Flower Hall 775.345.7482 charr@gmail.com Clayton 365 Sandy Hall 775.345.7350 charv@gmail.com 7892 Harvey 1359 William Bonahan 145 Mountain Hall 775.345.8945 wbona@gmail.com Dorm DORM_ID STUDENT_FNAME STUDENT_LNAME DORM DORM_ADDRESS 001 Jigisha Patel Peaceful Hall 123 Peace Ln. 002 Jose Moreno Tulip Hall 789 Tulip Ln. 003 Briana McDogual Bee Hall 45 Bee Ln. Cindy Chui Peaceful Hall 123 Peace Ln. 1. Student Select 2. Advisor Incorrect v 3. Dorm Incorrect v

Q: It relates to database as a service, or DaaS. What does it do and how does it work? What advantages…

A: The answer of the question si given below

Q: You've recently been hired as a Database Administrator at KCA University. Some departments have…

A: Introduction: Database Management System is the full form of DBMS. A database management system…

Q: You have been hired to design a database for a small company that places students in part-time jobs.…

A: The user requirements gathering procedure for the given problem is shown below -

Q: What other decisions are you going to take to ensure that a very robust and scalable system is…

A: For large volumes of data used in the database, Greenplum (SQL database) is the most efficient kind…

Q: What exactly is a database management system (DBMS)? We will use a coffee business as an example to…

A: DBMSs handle data coming in, organize it, and offer methods for users or other programmers to alter…

Q: End users should be involved in the selection of a database management system and database design.…

A: End user role is the key point for database management system and database design. In the next part…

Q: Suppose your company has built a database application that runs on a centralized database, but even…

A: In a centralized system, to handle the transaction load, query performance has to be improved.Query…

Q: By reducing redundancy in relational database tables,

A: In relational database tables by reducing reduni, the most important reason to perform normalization…

Q: Task 2 - Assume that you are working as a database administrator for XYZ Company. You are asked…

A: i. Revoke the privileges from the roles. When i am working as database administrator for any company…

Q: WEEK 9 ASSIGNMENT# 2   ANSWER THE QUESTION BELOW:   Most database management system (DBMS)…

A: An database management system (DBMS) is programming that permits associations to make, keep up with,…

Q: In this part you will be to map the EER schema design to a relational database schema, and create…

A: Customer (Name, IDNo, Address, Email, Username, Password) IDNo – Primary Key create table Customer…

Q: Assume that Marcia’s has the following personnel: two owners, a shift manager, a parttime…

A: Given: Assume that Marcia’s has the following personnel: two owners, a shift manager, a parttime…

Q: You have decided to build the database for John’s system. This question centres around the…

A: CREATE TABLE Persons(PersonID int primary key,LastName varchar(255),FirstName varchar(255),FOREIGN…

Q: descending order by duration. Name this query Q2 – CallDuration. c. For each customer who has a…

A: Finding customers for your business is not easy. And once you find them, there comes another…

Q: find that they need different kinds of databases for different tasks. Explain in detail to the…

A: - We need to show the five types of databases.

Q: Explore the index mechanisms used that used by both SQLite and MySQL. What kinds of indexes do each…

A: Indexing is effective  way for  optimizing  the performance of a database by minimizing the number…

Q: The National Identification Authority is in charge of collecting data on all residents and…

A: Intro For large volumes of data used in the database, Greenplum (SQL database) is the most…

Q: What is the difference between SQL performance tuning and database performance tuning? What are the…

A: Step 1  The answer is given in the below step

Q: explain the role of the Database   Administrator (DBA) which includes:   performance of a database…

A: Database Administrator (DBA): A database administrator (DBA) is the information technician/manager…

Q: "Mpho is very excited about the new information system to be built for his spaza shop. In this…

A: Let us create database entities for the shop. Let the three tables be Products, Customer, Sales .

Q: You have been given the task of documenting the process and commands required for creating a new…

A: Student_1 Ассess  соmmаnd  line  аnd  enter  MySQL  server:mysql The  sсriрt  will  return  this…

Q: Compare the functions/operations of two DBMS.  You need to research and investigate how each DBMS…

A: We need to figure out: DBMS Function MS-Access MySQL Data Dictionary Management…

Q: 1-What are the advantages of having the DBMS between the end user’s applications and the database?…

A: --advantage of having DBMS between end user application and the database  dbms help us to create an…

Q: What is a derived column, hows does it work, how it affects the performance of a database and how…

A: The above question is solved in step 2 :-

Q: trigger

A: A trigger is a special type of stored procedure in a database that automatically runs when a special…

Q: database

A: Given :- It is mention that for the Cities database, discuss one problem with either the correctness…

Q: Suppose you want to store the records of the employees of your company. They all have employee ID's…

A: Actually, given information is: Suppose you want to store the records of the employees of your…

Q: 1.1 The DBMS create and manages the complex structures required for data storage. Elaborate on the…

A: A data set administration framework (DBMS) is framework programming for making and…

Q: Why is an index on a database column created? A:To optimize data integrity B:To optimize data…

A: the index used in database column has great usability

Q: What kind of data redundancy have you discovered? What are the chances that such redundancies may…

A: Introduction: If data is kept in two or more locations, it will inevitably be redundant. This is a…

Q: BITS has decided to include I.T training in its service line and has assigned the item to the…

A: In this case, to carry over the data correctly you need to change the relationship. Change task can…

Q: Caltech is a training institution situated in Gauteng that provides training on database management…

A: Database and File System are two different methods that help to store, retrieve, manage and…

Q: Do you mind providing a comprehensive breakdown of the database's file structure?

A: Database: Database File system organizes files on a hard drive. File system organizes and retrieves…

Q: A local hotel invites you to improve their database system. They only have one large table with the…

A: Normalization:-   Normalization is the process of minimizing redundancy and organizing data to avoid…

Q: What database statistics measurements are typical of indexes? What are the typical database…

A: Statistics about the database: Database statistics are concerned with collecting numerical…

Q: training institution situated in Gauteng that provides training on database management systems…

A: Lets see the solution.

Q: discuss the various techniques you can use to gather relevant information for the development of the…

A: In this question we have to discuss about various techniques which can be used for development of…

Q: What are the types of normalization with respect to redundant and non-redundant database tables that…

A: Introduction of Normalization: In DBMS(Database Management System), normalization is the process to…

Q: The project team will embark on a data take-on exercise because an operational  system requires a…

A: Before going on how DBMS interface or in other words Database Interface works let us first know what…

Q: normalization

A: What is normalization? Normalization is a database or technique or procedure that lessens…

Q: In order to improve the performance of a database used primarily used for writing reports, it might…

A: When there is a requirement for reports writing from the database, there is always a requirement for…

Q: In order to increase efficiency, the DBA denormalized part of the data in the TAL Distributors…

A: One of the tables from Premier Products database after the DBA has denormalized the database is…

Q: Describe the sort of data redundancy you found. What are the chances that such redundancies will…

A: Detection of data redundancies Data redundancy is being detected when identical data is stored in…

Q: In order to increase efficiency, the DBA denormalized part of the data in the TAL Distributors…

A: The solution to the given question is: One of the tables from Premier Products database after the…

Q: Relational database integrity rules are especially important to good database design. Relational…

A: Rules of entity and referential integrity are given below: Entity Integrity: The requirement of…