Q1. An international company has several branches and projects all over the world. Consider the following global relational database schema for the company: EMPLOYEE SALARY DNO FNAME EMP ID MGR_ID LNAME BDATE ADDRESS DEPARTMENT DNAME DNO MGR_ID MGR_STARTDATE DEPT LOCATIONS DNO DLOCATION PROJECT PLOCATION DNUM PNAME PNO WORKS ON EMP ID PNO HOURS PAY_RATE

Q1. An international company has several branches and projects all over the world. Consider the following global relational database schema for the company: EMPLOYEE SALARY DNO FNAME EMP ID MGR_ID LNAME BDATE ADDRESS DEPARTMENT DNAME DNO MGR_ID MGR_STARTDATE DEPT LOCATIONS DNO DLOCATION PROJECT PLOCATION DNUM PNAME PNO WORKS ON EMP ID PNO HOURS PAY_RATE

Fundamentals of Information Systems

8th Edition

ISBN:9781305082168

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter3: Database Systems And Applications

Section: Chapter Questions

Problem 3PSE

See similar textbooks

Similar questions

Can you please answer these two questions:question 8 : In a DDB environment, the term used for the ability to easily expand the number of nodes in database is called:A) node replication B) expandability C) Horizontal scalability D) vertical scalability E) ease of usequestion 9: In a DDB environment, the term used for the ability to expand the capacity of an individual node in the database is called...A) Oreferred growth B) Expandability C) node transparency D) horizontal scalability E) vertical scalability
Web technology Question: Professor don't reject this....I need this answer otherwise I will report to administration....please answer it according to asked question. Q.No.2. Suppose there is a MySQL database named MyDatabase, the name of database server is DatabaseServer, User Name for the database server "Ghazi Messam" and Password is “1121” There is one table named tbl_Projects (ProjectSID, ProjectTitle, ProjectSupervisor,CellNo,Email). As project title is: Student Registration form As project supervisor is: Ghazi Messam As cell no: 03137025001 As Email is: ghazimessam@gmail.com You are required to design a HTML page to get the value for each of these attributes. Then finally post the data to next page and store the input data to database. Add Screen Shot of Creating database, Database Table and Sample Data.
solve with php and html Question 1 We need to create a web site for an online health centerCreate a database containing three tables (Name the DB by your name andID, for example, Fadi201930234):gender- id int Primary Key AutoIncrement- name varchar (25) Fill the table with some values Salutation- SID (int)- title (Varchar 10) Fill the table with some values Employee- empID int PrimaryKey Auto Increment- name varchar(25)- rate double- hours double- salutationID FK- genderID FK
4. What is type of prototyping is used especially for developing Web applications? Select One Evolutionary prototyping Extreme prototyping Incremental prototyping Throwaway Prototyping 5. Which is a simple file that describes the way the data is arranged in a database? Select One data dictionary entity relationship diagram Structured Query Language all of the above 6. What is a method widely used in software engineering that represents a system as a collection of objects that interact with one another? Select One Object-Oriented Planning CASE tools Object-Oriented Analysis and Design all of the above
Wally Los Gatos decides to pursue a law degree. After graduating, he has teamed up with Lyla El Pajaroto form Peck and Paw, Attorneys at Law. Wally and Lyla have hired you to design a database systembased upon the following set of business rules. It is in your best interest to perform a thorough analysis, toavoid needless litigation. Please create an ER model based up on the following set of rules:• an attorney is retained by one or more clients, for each case• attributes of attorney are: attorneyID, name (firstName, lastName), address (street, city, state,zipcode), specialty (may be more than one), bar (may be more than one)• a client may have only one attorney for each case• attributes of client are name (firstName, lastName), address, city, state, zipcode, telephone,dateOfBirth• a client may have more than one case• attributes of case are caseID, case_description, caseType• an attorney may have more than one case• each case is assigned to one and only one court• attributes of court…
SQLite and Postgres both manage relational databases, but there are things each database is better at. Name something Postgres is much better at than SQLite. Why is this true? Name something SQLite is much better at than Postgres. Why is this true? Give two examples of real-world database problems; one that favors each side
Referring to Appendix A below, code a php script to read data from the database and display the Items report below. Items reportToday's date: xxxxxxxxNumber Name Price Quantityxxxxxxxx xxxxxxxxxxxxxx xxxxx xxxxxxxxxxxxx xxxxxxxxxxxxxx xxxxx xxxxx APPENDIX A – Table definitions and initializations-- MySQL script to initialize a MySQL database and four tables:-- customer, detail, item, salesorder--DROP DATABASE IF EXISTS finaldb;CREATE DATABASE finaldb;USE finaldb;CREATE TABLE customer ( c_num varchar(16), c_name varchar(128));CREATE TABLE detail ( d_onum varchar(16), d_inum varchar(16), d_qty int);CREATE TABLE item ( i_num varchar(16), i_name varchar(128), i_price decimal(9,2), i_qty int);CREATE TABLE salesorder ( s_num varchar(16), s_cnum varchar(16), s_date date);INSERT INTO customer VALUES ('c101','Sam Paint'), ('c102','Ramon Hardware'), ('c103','Li Auto');--INSERT INTO detail…
Which of the following sets of terms describes the data in a database? Select one: a. integrated and shared b. redundant and accurate c. functional and redundant d. transactional and unconstrained
Provide a description, focusing on transparency, of the following minimum desired properties of a distributed database management system:One, being forthright and truthful about one's performanceReason No. 2: All monetary dealings and transactions are completely open
Subject:database administration and management question: select a database like customer tb,employee tb and customer tb make a set of predicate generate minterm predicate and fragments and make a correctness rule of fragmentation
It is generally accepted that database architectures may be separated into two or three layers depending on their particular demands. What benefits come from switching to a three-tier database architecture? Discussbriefly
View 2 Seneca Courses Inc. Product Spreadsheet All the course books are maintained on the following Product spreadsheet. SCI is currently having difficulty searching for books written by the same author, and would like the new database system to list each author separately. There can be one or many authors for each book, but there is no limit to the number of authors of a book. PROD ID TITLE EDITION Purchase Cost Retail Price AUTHOR 100860 DATABASE SYSTEMS: DESIGN AND IMPLEMENTATION THIRD EDITION $84.98 $99.98 CARLOS CORONEL, PETER ROB 100861 DATABASE SYSTEMS: DESIGN AND IMPLEMENTATION FOURTH EDITION $92.82 $109.20 CARLOS CORONEL, PETER ROB 100871 MODERN RETAILING FOURTH EDITION $88.36 $110.45 DANIEL CASTON, JENNY TAPSCOTT 100890 UNDERSTANDING MICROSOFT ACCESS NINTH EDITION $65.52 $72.80 PIERRE LEBLAND, ROBERT COBB 102130 ORACLE: INTRODUCTION TO PL/SQL $53.24 $59.15 PHILIP ROBB 200376 ORACLE:…