DATA_ORG_1NF JOB CLASS Elect. Engineer Database Designer Database Designer Programmer Systems Analyst Applications Designer General Support Systems Analyst DSS Analyst Database Designer Systems Analyst Delbert K. Joenbrood * Applications Designer Clerical Support Programmer Programmer Systems Analyst Database Designer Applications Designer Systems Analyst General Support DSS Analyst PROJ_NAME - EMP_NU - EMP_NAME CHG_HOL - HOUR- PROJ_NL 15 June E. Arbough 84.50 23.8 Evergreen Evergreen Evergreen Evergreen Evergreen 103 101 John G. News 105.00 19.4 105 Alice K. Johnson * 105.00 35.7 106 William Smithfield 35.75 12.6 15 102 David H. Senior 96.75 23.8 18 Amber Wave 114 Annelise Jones 48.10 24.6 18 Amber Wave 118 James J. Frommer 18.36 45.3 18 Amber Wave 104 Anne K. Ramoras 96.75 32.4 18 Amber Wave 112 Darlene M. Smithson 45.95 44.0 Rolling Tide Rolling Tide Rolling Tide Rolling Tide Rolling Tide Starflight Starflight Starflight Starflight Starflight Starflight Starflight 22 105 Alice K. Johnson 105.00 64.7 22 104 Anne K. Ramoras 96.75 48.4 22 113 48.10 23.6 22 111 Geoff B. Wabash 26.87 22.0 22 106 William Smithfield 35.75 12.8 25 107 Maria D. Alonzo 35.75 24.6 25 115 Travis B. Bawangi 96.75 45.8 25 101 John G. News 105.00 56.3 25 114 Annelise Jones 48.10 33.1 25 108 Ralph B. Washington 96.75 23.6 25 118 James J. Frommer 18.36 30.5 25 112 Darlene M. Smithson 45.95 41.4 0.00 0.0 535554

Q: 114. A tool that can help designers understand the dependencies of database structures is a: a.…

A: Given data: A tool that can help designers understand the dependencies of database structures is…

Q: 3.1 Normalize TABLE 2 below to 2NF TABLE 2 Studentnum 401 Course CSE Math CSE, CSE, applied stats…

A: The given problems are related to the database designing and normalization where    3.1) Needs to…

Q: 1) Storing same data in many places is called a) iteration b) redundancy c) concurrency d)…

A:

Q: 1. Which of the studied data structures in this course would be the most appropriate choice for the…

A: a).Array We will be using array because of the functionality of random access that which is possible…

Q: Consider the following relational database schema that contains information about employees and…

A: {pid,pname} {pid,pname,budget} {pname,managerid} {pname,budget,managerid}

Q: Use MYSQL workbench to transform the following E-R data model into a relational database design:…

A: Here we were given with E - R data model and to convert it into relational database design there are…

Q: Icus FRAME Question 7 Consider the following Database Schema. CUSTOMR IYOICE PK CUA CODE LNE PK…

A: we need to provide  SQL query to determine how many products have a price that is less than $10.

Q: 8. Consider the following database tables dept.jname Physics Finance History Comp. Sci. Elec. Eng.…

A: a. The SQL command for creating tables “teacher” and “department” with the required primary and…

Q: 4. Consider the following GRADEBOOK relational schema describing the data for a grade book of a…

A: Relation schema defines the design and structure of the relation like it consists of the relation…

Q: Q1. As a data structures analyst, you are to recommend the efficient data structure with supporting…

A: A company is developing a database system containing information about cities and towns in the…

Q: 8. _____________ is a classical approach to database design? a. Left – Right approach b. Right –…

A: Given that, ___________ is a classical approach to database design? a. Left – Right approach b.…

Q: Question 1 A city college would like to maintain their academic information in a MySql database…

A: As for our rules we can answer only one question at a time. Please Post as separate question. I will…

Q: LECTURER # employee id * TC ld * title * first name work in last name * phone o email DEPARTMENT…

A: According to the question Here we have 3 relationships between Department and Lecturer.  The 1st…

Q: 2. Consider the relations Students, Faculty, Courses, Rooms, Enrolled, Teaches, and MeetsIn defined…

A: Relational Model A relation is a table with columns and rows. It is based on the mathematical…

Q: Create a Crow’s Foot ERD for each of the following descriptions. (Note: The word many merely means…

A: Database Management System is essentially a software or application package that controls the…

Q: Consider the following schema for a company database and answer the following questions: DEPARTMENT…

A: CREATE statement is used to create any table in the database.  The language to create the data base…

Q: Question 4 Given the Database Design Language (DBDL) for Rio Massage Centre as follows: Note: Date…

A: AppointmentDetails is the name of the table which contains 4 columns. Let ApptNo os the primary key…

Q: med type wall papers media upleads wp desc Has med title med id wp name med name img dese img id img…

A: According to the given problem statement we are required to create a SQL code that is used to make…

Q: 2):-When a table has no suitable _ key, the database designer speciiesa(n)__ a) primary, foreign…

A: The given questions are related to desingng the data base as logical model (ER model) as wella s…

Q: LECTURER DEPARTMENT give lesson # employee id • TC ld * title * first name work in • last name # id…

A: Here we have 3 relationship between Department and Lecturer.  The 1st relationship teach in is a M:N…

Q: Transform the table into 1NF, 2NF, and 3NF. Create a database diagram afterward. program subject…

A: 1NF:- A table is to be 1NF if there are no multivalued attributes and multi-group recurrent…

Q: To reduce the communication cost of remote applications with high access frequency, it is required…

A: Queries are: App1: select hours * pay_rate as payment from works_on, project where plocation =…

Q: To reduce the communication cost of remote applications with high access frequency, it is required…

A: Queries are: App1: select hours * pay_rate as payment from works_on, project where plocation =…

Q: Question  A city college would like to maintain their academic information in a MySql database…

A:

Q: to asked question. Q.No.2. Suppose there is a MySQL database named MyDatabase, the name of…

A: Database output can't be shown as the server metioned is something which can't be run in local…

Q: Suppose you have the following relational database scheme for a real estate agency:   Real Estate…

A: Real Estate Office (officeID, street, city, postalCode)-> officeID is the primary key as primary…

Q: Suppose you have the following relational database scheme for a real estate agency:   Real Estate…

A: A primary key is an attribute in a database table that uniquely identifies each tuple (rows). A…

Q: TSERVICE DRIVER ID1 ID2 dlnumber enumber first-name last-name phone [0.. ] BUS departure-city…

A: Relation schema is a tabular representation of database. The class TSERVICE is a base class and…

Q: 3: Come Q3 Normalize the following table, given 1NF, 2NF and BCNF: Title Author1 Author2 ISBN…

A: Given table contain 2 rows and it contain multivalued attributes. So, this table is not in 1 NF. 1…

Q: Which data model has the highest level of abstraction? O a. Relational O b. Object-oriented O c.…

A: In this answer I will be discussing about the data model has the highest level abstraction.

Q: 1. Consider the following relations: Student (snum: integer, sname: string, major: string, level:…

A: Student (snum: integer, sname: string, major: string, level: string, age: integer) Class (name:…

Q: Ider the following ER mödel, A) describe the database entities, attributes, relationships and other…

A:

Q: Which of the studied data structures in this course would be the most appropriate choice for the…

A: a) We will use Array because of Random access in Array elements. b) Array since they  are best when…

Q: Database Design   Testing (ID_testing,date,observerId) Observer(observerId,observer_name)…

A: ER- model: ER-model is used for high level Database design ER-model contains the following Entity…

Q: Typically, a hospital patient receives medication that have been ordered by a particular doctor.…

A: Lets write the business logic first. The business rules between PATIENT and ORDER will be.• A…

Q: Answer All the questions: Consider the below Student table and write the appropriate relational…

A: In the problem, it is mentioned to write a relational query. Here I am using MySQL for this. In the…

Q: O.No.2 Data Modeling Concepts [CLO- The below table shows lecture details of different faculty…

A: I have drawn the ERD according to the following specification. There are mainly 4 entites, Students,…

Q: Subject:database administration and management question: select a database like customer…

A: Diagram of dependency among relations:               Architecture of Distributed Database:

Q: Consider the following Database Schema. CUSTOMER PK CUR CODE INVOICE LINE PK IY HUMBER contains…

A: we need to Write a SQL query to list the product code, vendor code, and vendor name for all products…

Q: Consider the following Books database which is used to keep track of books and their readers. Assume…

A: Given:

Q: 2. Consider the relations Students, Faculty, Courses, Rooms, Enrolled, Teaches, and MeetsIn defined…

A: We are provided with 7 relations : Students, Faculty, Courses, Rooms, Enrolled, Teaches, MeetsIn…

Q: It's a Database Administration advanced data modeling question. Given the following business…

A: Crows Foot ERD of Two-Bit Drilling Company • The situation is that company holds the information of…

Q: 1. The table shows a class list for the XYZ UNIVERSITY, convert this user view to a set of 3NF…

A: Convert the user view to 3NF relations:   The class list of XYZ UNIVERSITY for First semester is…

Q: A company has a single table in a computer(e.g a spreadsheet) in which every information about each…

A: 1)    A company has a single table in a computer(e.g a spreadsheet) in which every information about…

Q: When converting an ERD to a database design, Foreign key(s) for a M:N (many-many) relationship are…

A:

Q: Create a MYSQL database table named Employees as the following. ID Frist_name Last_name Department…

A: Database CREATE TABLE EMPLOYEES (ID INT, FIRST_NAME VARCHAR(10) , LAST_NAME VATCHAR(10), DEPARTMENT…

Q: 1. Create the table with the following specification shown below: Database name: Oasis. Table name :…

A: We are using mysql for this. Create database as shown below: mysql> create database BB;Query OK,…

Q: QUESTION 8 Answer All the questions: Consider the below Student table and write the appropriate…

A: Relational algebra query to display the details of students who study programming course and also…

Q: A database containing data about parking violations contains no transitive dependencies. Which of…

A: I have given an answer in step 2.

Q: consists of three relations, whose schemas are: Sailors(sid, sname, rating, age) Boats(bid, bname,…

A: We are going to write relational algebra query for the query - finding all information of sailors…