Homework Answers
6)
a)
This table is in 2NF since there is not partial dependency in the relation. However, it is not in 3NF since it has a transitive dependency.
b)
The normalized relations are:
CUS (CUS_NUM, CUS_ADDRESS, CUS_PHONE)
INV (INV_NUM, INV_DATE, INV_AMOUNT, CUS_NUM)
The dependencies are:
CUS_NUM -> CUS_ADDRESS, CUS_PHONE
INV_NUM -> INV_DATE, INV_AMOUNT, CUS_NUM
NOTE: As per Chegg policy I am allowed to answer specific number
of questions (including sub-parts) on a single post. Kindly post
the remaining questions separately and I will try to answer them.
Sorry for the inconvenience caused.
Add Answer to:
This is about database system. Thank you.
Question A1 You are given with three Oracle tables,...
This is about database system. Thank you. Question B1 Create a Crow's Foot ERD with the...
This is about database system. Thank you.
Question B1 Create a Crow's Foot ERD with the business rules described below. Write all appropriate connectivities and cardinalities in the ERD. A music store would like to develop a database to manage information about the CDs, or vinyl collection, the customers and transactions information. It stores the relationships between artists, albums, tracks, customers and transactions. Here is the list of requirements for the database: The collection consists of albums. An album is...
HELP DATABASE QU Question 1: Think About the relational database table data as given below, write...
HELP DATABASE QU
Question 1: Think About the relational database table data as given below, write the following queries in Oracle SQL. Company (Cid, Cname, City, Budget, Branch) Department (Deptno, Dname, Building, Cname) Employee (Ename, Deptno, Street, City, Phone, Salary) Works (Ename, Deptno, Hire_date) Location (Cname, Location ) 1. Write Query to Create the Company table, suggest appropriate data type of each attribute, consider that there should be a name for each company. 2. Find employee name/names who live in...
Exercise 3 [12.5 marks] Given the Restaurant management system database that contains the following tables (primary...
Exercise 3 [12.5 marks] Given the Restaurant management system database that contains the following tables (primary keys are underlined and foreign keys are preceded with #): Customer (customerID,customerFirstName,customerLastName,customerAddress) Oreder (orderID,orderDate, #customerID,#menuItemID,#staffID) MenuItem(menuItemID, menuItemName,ingredients,type,availability) Staff(staffID, staffName, staffPhoneNumber, staffRole ) OrderPayment(paymentID,paymentAmount,#orderID,#staffID) 1) Without using DISTINCT, write the SQL query equivalent to the following one:[1.5 marks] SELECT DISTINCT menuItemName FROM MenuItem WHERE type = ‘Vegetarian’ OR availability= ‘Yes’; 2) Express the following queries in SQL: a) Find the number of orders placed by...
Topic: Inventory Manangement Part A. Database Creation Your database should have a minimum of 4 tables...
Topic: Inventory Manangement Part A. Database Creation Your database should have a minimum of 4 tables and include both one-to-many and many-to-many relationships. Be sure to include some numeric and/or date fields. Define all appropriate constraints, using the proper naming conventions (see Structure Notes below). Populate your database with at least 30 records in the main table(s), and whatever is needed in related tables. Submit the following: • a short description of the purpose of the database and what the...
CHAPTER 1: DATABASES AND DATABASE USERS Given the simple Doctor-Treats_Patient database schema which contains three files...
CHAPTER 1: DATABASES AND DATABASE USERS Given the simple Doctor-Treats_Patient database schema which contains three files describing information about doctors and patients they treat as follows, answer the following questions with regards to this database. (Total for que 1 is 10 marks) Doctor (DocID: string, DName: string, DAddress: string, Numpatients: integer) Treats (DocId: string, SSN: string, illness: string, day: string, cost: real) Patient (SSN: string, PatientName: string, PAddress: string, Age:integer) Note : DocID, DName, DAddress and Numpatients...
database and sql problme THE QUESTIONS 3, 4,5 and 6 REFER TO THE RELATIONAL TABLES LISTED...
database and sql problme
THE QUESTIONS 3, 4,5 and 6 REFER TO THE RELATIONAL TABLES LISTED BELOW CREATE TABLE Department ( DECIMAL(5) VARCHAR(30) CHAR(5) DATE NOT NULL NOT NULL NOT NULL * Department number /*Department name * Department manager number */ /Manager start date DNumber DName Manager MSDate CONSTRAINT Department_PK PRIMARY KEY(DNumber) CONSTRAINT Department_CK UNIQUE(DName) CREATE TABLE DeptLocation DECIMAL(5) VARCHAR(50) NOT NULL NOT NULL DNumber * Department number */ * Department location */ Address CONSTRAINT DeptLocation_PK PRIMARY KEY(DNumber, Address) CONSTRAINT...
Question 1.Write a SQL statement for each of the following questions based on the above tables...
Question 1.Write a SQL statement for each of the following
questions based on the above tables (50 Points).
1) Create “Enrollment” table.
2) Change the credits of “Database” course from 2 to 3.
3) List the course titles (not Course_No) and grades John Doe
had taken.
4) Calculate average of Café Balance, and name new field as
Average Balance.
5) Create a roster for “Database” course (list student ID, last
name, first name, major, and status for each student enrolled...
SQL QUERIES 1) Using the Product and PC relations, create both tables in your database and...
SQL QUERIES
1) Using the Product and PC relations, create both tables in
your database and insert all the data. Show the SQL statements to
create each table and show a representative SQL insert statement
for the data in each table (i.e. you do not need to show insert
statements for all the data).
– For the remaining questions, assume that your SQL is part of
a program function and the function provides the input needed for
your SQL query....
Q1: The following question are based on these database tables: EMPLOYEE FNAME MIDINT LNAME SSN BDATE ADDRESS SEX SALARY SUPER_SSN Dept_No James A Borg 123123123 Hous...
Q1: The following question are based on these database tables: EMPLOYEE FNAME MIDINT LNAME SSN BDATE ADDRESS SEX SALARY SUPER_SSN Dept_No James A Borg 123123123 Houston, TX M 55000 Null 1 Franklin S Wong 234234234 Houston, TX M 40000 123123123 5 John Q Smith 345345345 Houston, TX M 30000 234234234 5 Jennifer L Wallace 456456456 Bellaire, TX F 43000 123123123 4 Alicia M Zalaya 567567567 Spring, TX F 25000 456456456 4 Ramesh R Narayan 678678678 Humble, TX M 38000 234234234...
Given the following three tables: Customer(CustId, CustName, PhoneNum) Customer: CustId CustName PhoneNum 1 Ahmad Ali 0555555555...
Given the following three tables: Customer(CustId, CustName, PhoneNum) Customer: CustId CustName PhoneNum 1 Ahmad Ali 0555555555 2 Sara Ahmad 0544444444 3 Mona Saad 0533333333 Tabless(TableNum, NumOfSeats) Tabless: TableNum NumOfSeats 1 4 2 4 3 2 4 6 Bookings(BookingNum, CustId, BDay, BMonth, BYear, BHour, NumOfPeople, TableNum) Bookings: BookingNum CustId BDay BMonth BYear BHour NumOfPeople TableNum 1 2 10 12 2019 7 2 3 2 3 30 12 2019 10 4 2 3 1 1 1 2020 11 5 4 4 3...
This is about database system. Thank you.
Question B1 Create a Crow's Foot ERD with the business rules described below. Write all appropriate connectivities and cardinalities in the ERD. A music store would like to develop a database to manage information about the CDs, or vinyl collection, the customers and transactions information. It stores the relationships between artists, albums, tracks, customers and transactions. Here is the list of requirements for the database: The collection consists of albums. An album is...
HELP DATABASE QU
Question 1: Think About the relational database table data as given below, write the following queries in Oracle SQL. Company (Cid, Cname, City, Budget, Branch) Department (Deptno, Dname, Building, Cname) Employee (Ename, Deptno, Street, City, Phone, Salary) Works (Ename, Deptno, Hire_date) Location (Cname, Location ) 1. Write Query to Create the Company table, suggest appropriate data type of each attribute, consider that there should be a name for each company. 2. Find employee name/names who live in...
database and sql problme
THE QUESTIONS 3, 4,5 and 6 REFER TO THE RELATIONAL TABLES LISTED BELOW CREATE TABLE Department ( DECIMAL(5) VARCHAR(30) CHAR(5) DATE NOT NULL NOT NULL NOT NULL * Department number /*Department name * Department manager number */ /Manager start date DNumber DName Manager MSDate CONSTRAINT Department_PK PRIMARY KEY(DNumber) CONSTRAINT Department_CK UNIQUE(DName) CREATE TABLE DeptLocation DECIMAL(5) VARCHAR(50) NOT NULL NOT NULL DNumber * Department number */ * Department location */ Address CONSTRAINT DeptLocation_PK PRIMARY KEY(DNumber, Address) CONSTRAINT...
Question 1.Write a SQL statement for each of the following
questions based on the above tables (50 Points).
1) Create “Enrollment” table.
2) Change the credits of “Database” course from 2 to 3.
3) List the course titles (not Course_No) and grades John Doe
had taken.
4) Calculate average of Café Balance, and name new field as
Average Balance.
5) Create a roster for “Database” course (list student ID, last
name, first name, major, and status for each student enrolled...
SQL QUERIES
1) Using the Product and PC relations, create both tables in
your database and insert all the data. Show the SQL statements to
create each table and show a representative SQL insert statement
for the data in each table (i.e. you do not need to show insert
statements for all the data).
– For the remaining questions, assume that your SQL is part of
a program function and the function provides the input needed for
your SQL query....
Most questions answered within 3 hours.
-
In the following concepts of economics provide a
discussion of the meaning as well as the...
asked 5 seconds from now -
The table below shows the number of deaths in the U.S. in a year
due to...
asked 13 minutes ago -
Suppose we now care about the long run decisions of a firm that
has a production...
asked 13 minutes ago -
Two tugboats pull a disabled supertanker. Each tug exerts a
constant force of 1.20×106 N ,...
asked 24 minutes ago -
Outline the major trends shaping franchising
asked 30 minutes ago -
The solubility of magnesium phosphate is 2.27 × 10-3 g/1.0 L of
solution. What is the...
asked 30 minutes ago -
. Pendulum Inc. uses moving-average costing. Its 20X8
ending inventory is 900 units that have an...
asked 29 minutes ago -
This is a question about selling :
Abby has been working with a couple for a...
asked 32 minutes ago -
For water, Kf = 1.86 °C∙kg/mole, Kb = 0.52 °C∙kg/mole and
density = 1.00 g/mL. Calculate...
asked 44 minutes ago -
Why in 100 words Social Darwinism have such broad appeal? please
type
asked 45 minutes ago -
Should we be concerned about corporations that just don't seem
to care if sexual harassment occurs?...
asked 50 minutes ago -
Plese use R-Studio to answer this question.
qbinom(p, size, prob) gives the smallest x value so...
asked 50 minutes ago