Department Employee • Code Name Manager .ID Name Salary 44 Engineering 2538 2538 Lisa Ellison 45000 82 Sales 3829 5384 Sam Snead 30500 12 Marketing 6381 6381 Maria Rodriguez 92300 99 Technical Support NULL In the Department table, which foreign key value violates referential integrity? 2538 3829 NULL

Department Employee • Code Name Manager .ID Name Salary 44 Engineering 2538 2538 Lisa Ellison 45000 82 Sales 3829 5384 Sam Snead 30500 12 Marketing 6381 6381 Maria Rodriguez 92300 99 Technical Support NULL In the Department table, which foreign key value violates referential integrity? 2538 3829 NULL

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter3: The Relational Database Model

Section: Chapter Questions

Problem 25P: Create the ERD. (Hint: Look at the table contents. You will discover that an AIRCRAFT can fly many...

See similar textbooks

Similar questions

This organization provides following functionalitiesEmergency Care 24x7Support GroupsSupport and Help Through callsAny new Patient is first registered in their database before meeting the doctor. TheDoctor can update the data related to the patient upon diagnosis (Including thedisease diagnosed and prescription). This organization also provides rooms facility foradmitting the patient who is critical. Apart from doctors, this organization has nursesand ward boy. Each nurse and ward boy is assigned to a doctor. Also, they can beassigned to patients (to take care of them). The bill is paid by the patient with cashand E-banking. Record of each payment made is also maintained by the organization.The record of each call received to provide help and support to its existing person isalso maintained.Check clinic management system project in PHP
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.
_&plase helo with Course: Database *(SQL)* Please excute the given SQL script (https://drive.google.com/file/d/1zxe_aOhERjVCL54_zbgSLkFTRHYQhOPW/view?usp=sharing) for accessing the data. The data is described in the following relation schemas: Airport (airportID, name, city) Passenger (ticketNo, name, nationality, flightNo, seatNo)FK: flightNo references Flight (flightNo)FK: seatNo references Seat (seatNo) Flight (flightNo, flightCompany, departAirport, arrivalAirport)FK: departAirport references Airport (airportID)FK: arrivalAirport references Airport (airportID) Seat (seatNo, flightNo, class)FK: flightNo references Flight (flightNo) #Construct the SQL statements based on following transactions:1. Retrieve all rows in Airport table for all the airports in London city.2. Retrieve all British and German passengers.3. Retrieve all names of all the passengers..
Computer Science The following script uses a derived table to return he date and invoice total of the earliest invoice issued by each vendor. Write a script that generates the same results set but uses a temporary table in place of the derived table. Make sure your script tests for the existence of any objects it creates. Use itse2333; SELECT VendorName, FirstInvoiceDate, InvoiceTotal FROM Invoices JOIN (SELECT VendorID, MIN(InvoiceDate) as FirstInvoiceDate FROM invoices GROUP BY VendorID) as FirstInvoices ON (Invoices.VendorID = FirstInvoice.FirstInvoice.VendorID and Invoices.InvoiceDate = First.Invoice.FirstInvoiceDate) JOIN Vendors ON Invoices.VendorID = Vendor.VendorID ORDER BY VendorName, FirstInvoiceDate);
The following attributes fom1 a relation that includes information about individua l computers, their vendors, software packages running on the computers, computer users, and user authorizations. Users are authorized to use a specific software package on a specific computer d uring a specific time frame (characterized with attributes UserAuthorization Starts and UserAuthoriza tionEnds and secured with UserAuthorizationPassword}. Software is licensed to be used on specific computers (potentially multip le software packages at the san1e time) until an expira tion time (SoftwarelicensePrice) a t a specific price. Computers are sold by vendors, and each vendor has a support person with an ID, nan1e, and phone extension. Each individual computer has a specific purchase price. The attributes are as follows: Based on this information, a. Identify the functional dependencies between the attributes. b. Identify the reasons why this relation is not in 3NF. c. Present the a ttributes organized so…
Aert dont submit AI generated answer. Identify and justify the nature of the relationship (1:1 or 1:m or m:n) Customers and Orders tables Shippers and Orders tables
Lili Company 1 (Use C programming language and struct)Lili has a company, so it has a lot of employees.However, many of Lili employees have changed, resigned, and retired, causing the databasethat Lili has not synchronized properly. For that reason, Lili asks for your help to helpher make a list of Lili employees.Each employee has 3 attributes:• Name (max 20 character)• Gender (Laki-laki / Perempuan)• Division (Management / Accounting / HRD)There are several things you can do on the Lili database :1. Add EmployeeIn the add employee feature, the new employee will be after the old employee (ifall positions are full). Because Lili does not like to have employees who have thesame name, if there are employees who have the same name, the employee will notbe accepted to work at Lili’s company. New employees will always fill the leftmostplaces in the database to get a large salary.2. Change PositionThe employee’s position determines the employee’s salary, if the employee is in thefirst…
Many-to-Many ERD CUSTOMER has: customer_id first and last names address TAPE has: tape_id title description length in minutes A CUSTOMER may rent many TAPEs. A TAPE can be rented by many CUSTOMERs. Draw a Crow’s Foot ERD that includes the bridge table between Customer and Tape to account fully for the many-to-many relationship. Course and Class ERD Table name: COURSE COURSE_ID TITLE DESCRIPTION CREDITS ACCT-211 Basic Accounting An introduction to accounting. Required of all business majors. 3 CIS-380 Database Systems I Database design and implementation issues. Uses CASE tools to generate designs and implement in a major RDBMS. 3 CIS-490 Database Systems II The second half of CIS-380. Basic Web database application development and management issues. 4 Table name: CLASS CLASS_ID COURSE_ID SECTION TIME LOCATION 100 ACCT-211 1 8:00 a.m. – 9:30 a.m. T-Th. AA 325 101 ACCT-211 2…
Using the DBMS 130 Course Project ERD and Table Details spreadsheet, develop an APEX script to CREATE the 6 tables and all the constraints (PK, FK, NOT NULL, etc.).Add these two constraints to the FLIX_MOVIES table1. Movie Rating can only have these values: a. Gb. PGc. PG13 or PG-13d. R2. Movie Category can only have these valuesa. DRAMAb. COMEDYc. ACTIONd. SCIFIe. DOCUMENTARY
. It comprises the following tables: in AccessCRYPTOCODES: A list of 17 currencies the company is interested in.CRYPTOHISTORY : Several years of daily activities for the 17 currencies.CRYPTOCOINS-2018-2-9: Details of known currencies that were activewhen the data was complied.Exchanges-2018-2-9: A list of active exchanges on 2018-2-9 (provided as an excel file).You are asked to prepare several queries, as well as some reports.
Slove this Q? a. Briefly discuss database auditing. List at least four importance and at least threeobjectives of database audit.a. Muscat Funds is a company that provides loan to its members. A member can avail aloan not more than 10,000 OMR. Muscat Funds management wants to record andmonitor any new loan granted which are more than 10,000 OMR. Write an audittrigger command for the given scenario that will include the member id, type of loan,granted loan amount, username and the date record has been added.Your solution must include the necessary SQL commands and brief explanation for eachof the steps.Note: Any object created should include student ID. For example, User2_15F1234. If theuser names are inappropriate, marks shall be deducted accordingly
Loan Star Credit Services Inc. (LSCS) receives from various parties requests to investigate the credit status of customers. Each credit request is identified by a Request_ID and is described by a Request_Date, Requesting_Party_Name, and Request_Period (whose value is derived by the request date and current date). LSCS also receives results of credit checks. Each credit check is identified by a Credit_Check_ID and is described by Credit_Check_Date and Credit_Check_Result. LSCS associates each credit request with a credit check. Each credit check result may be used in support of one to many credit requests. A credit request may be recorded before its credit check date. Draw an entity-relationship diagram (ERD) for this situation using the Crow's foot notation introduced in class. You may download and modify this template file (using Draw.io site Links to an external site.; click "File > Open from > Device ..." and navigate to the file you downloaded) for your drawing in this part,…

SEE MORE QUESTIONS

Recommended textbooks for you

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Principles of Information Systems (MindTap Course…

Computer Science

ISBN:

9781285867168

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Principles of Information Systems (MindTap Course…

Computer Science

ISBN:

9781285867168

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS