23F-A5 (1)
.docx
keyboard_arrow_up
School
Carleton University *
*We aren’t endorsed by this school
Course
3005B
Subject
Computer Science
Date
Dec 6, 2023
Type
docx
Pages
3
Uploaded by CountMeerkat3468
COMP 3005B
Assignment #5
Due: Nov 26
Instruction
1.
You should do the assignment independently. If copying is found, the case will be reported to
the office of the Dean of Science immediately.
2.
Do this assignment directly on this document, rename it with your last name+first name, and
submit it to
brightspace
. Make sure your uploaded file can be opened and is correct.
Part 1 ER (10 marks)
Map the generated ER diagram in A4 Part 3 into a relational database schema.
(10)
Part 2 EER (40 marks)
Extend the ER Diagram created in A4 Part 3 with the following additional information.
a)
A person is either a student or an employee.
b)
A student is either an undergraduate student or a graduate student. A graduate student is
either a Master’s student or Ph.D student.
c)
An employee is either a chair, instructor
d)
An instructor is either a professor or a lecturer.
e)
A course is either an undergraduate course or a graduate course
f)
An undergraduate course section is taught by a lecturer and is taken only by undergraduate
students
g)
A graduate course section is taught only by a professor and is taken only by graduate
students.
h)
A professor also supervises up to 3 Ph.D students and up to 6 Master’s students.
2.
Draw the EER diagram for this information system that can represent the constraints
specified above.
(30)
3.
Map the EER diagram into a relational database schema.
(10)
Part 3. FD (10 marks)
1.
Consider the following relation. Which of the following functional dependencies may hold in
this relation? If the dependency cannot hold, explain why by specifying the tuples that cause
the violation.
(5)
(
1
)
A → B
(
2
)
B → C
(
3
)
C → B
(
4
)
B → A
A
B
C
a1
b1
c1
a1
b2
c2
a2
b3
c3
a3
b3
c4
a1
b3
c1
G
H
F
(
5
)
C → A
2.
Disprove the following inference rules.
a.
A → B, A →
C
⊨
B → C
(2)
b.
AB → C, B → D
⊨
C → D
(3)
Part 4. FD/MVD (10 marks)
Given the following inference rules:
(R0) X → XX
(R1) if X
Ê
Y, then X → Y
(R2) X → Y
⊨
XZ → YZ
(R3) X → Y, Y → Z
⊨
X → Z
Prove or disprove the following inference rules for functional/multi-valued dependencies.
1. A → B, A → C
⊨
C→ B
(2)
2. A → C, AC → B
⊨
A → B
(2)
3. A → B and C
⊆
B and D
⊆
C
⊨
A → D
(2)
4. A
↠
B
⊨
A → B
(2)
5. A → B, C → D
⊨
AC → BD
(2)
Part 5 ( 30 marks)
Given a first normal form relation
FIRST
with attributes {A, B, C, D, E, F, G, H} with the
dependency diagram as follows:
Dependency Diagram
A
B
E
D
B
C
FIRST
A
B
C
D
E
F
G
H
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Part 1) Open up Assignment 5 Original file from the Canvas Assignment, and save it to your local
computer. Click on the Problem 1 worksheet. What is the spreadsheet telling you? If there is a
problem, what is the problem? If there is a problem, where is the problem and what can you do about
it, e.g. how would it be fixed?
arrow_forward
Upload answer sheets
Define step by step algorithm for the previous question. Explain the flow of the program in your own terms, especially, when control goes to function 2 from main method, not more than two pages.
Once you upload files from your second device, click on
Sync
to check your submission
arrow_forward
Blackboard Submission Instructions:
1. Group Assignment Submission Link is located in the assessment section on blackboard.
2. Include the group members names as a comment at the top of the source code. e.g. // Eman
Alyahyan
3. Upload program source files OR copy the source codes into a ( .txt ) files.
4. Upload screenshots of programs' outputs.
Problem: (5 Marks)
There are two scientists working on set of numbers. The first person is looking for two numbers
specifically. The second person is responsible for entering all data. Help the first person to know if
the numbers set entered by the second person includes the two numbers he is looking for!
Input
The first person shall enter two numbers. The second person enters set of numbers of any size. S/he
can enter any range of numbers (up to you how to read those numbers).
Output
Message showing if both numbers entered by the first person have been found or not. If one of the
numbers was found show which one has been found. Hint: you may…
arrow_forward
A-List
Objective:
At the end of the exercise, the students should be able to:
▪ Create an adjacency list in Java.
Software Requirements:
▪ NetBeans IDE
Java Development Kit (JDK) 8
Procedure:
1. Create a folder named LastName_FirstName in your local drive. (ex. Reyes_Mark)
2. Using NetBeans, create a Java project named AdjacencyList. Set the project location to your own
folder.
3. Create an adjacency list based on the given graph.
B
A
с
E
D
F
G
arrow_forward
Week 4 IPO
Assignment Content
There are 4question Create IPO chart
q1. When Trina began her trip from New York to Florida, she filled her car's tank with
gas and
reset its trip meter to zero. After traveling 324 miles, Trina stopped at a gas station to refuel; the
gas tank required 17 gallons.
arrow_forward
Code Listing to shows the template for the build process.
arrow_forward
For the below code I need to add a history list with below conditions,
Objectives
Extend the functionali of the the calculator to save and display the past results of the arithmetic operations
Stage 2: Save and display calculation history of the calculator
In this second stage of the assignment you will extend the given calculator program to record the calculations, and recall them as a list using an additional command '?'.
Task 1: Study the given code in the answer box and extend it to save each executed operation in a Python List.
Declare a list to store the previous operations
Save the operator, operands and the results as a single string, for each operation after each calculation
Task 2: implement a history() function to handle the operation '?'
Display the complete saved list of operations (in the order of execution) using a new command ‘?’
If there are no previous calculations when the history '?' command is used, you can display the following message…
arrow_forward
It would be helpful if you could provide a suggestion to enhance the way a file is organized.
arrow_forward
Lab Assignment 2: Playfair Cipher
Overview: You are required to use the Playfair cipher to encrypt the message: "Butch." You will
do the encryption by hand. The key for encryption is “Govern." You will need to show your work
for the encryption process. Your submission should be a typed text file
arrow_forward
Sequence Diagram for the use case text below:
Basic Course
The student views the Grad Check Home Page and clicks on the Edit Schedule button. The system then displays the Current Student Schedule. On this page, the student may then choose a course to delete a course or to add a course. After the student performs these tasks, the system asks the user to save the changes on the Save Changes page. If the student selects Yes, the system updates the student record file. Otherwise, the student record is not updated.
Alternate Course
The student record file is unavailable: display Unable to Save page to the Student.
arrow_forward
Doing some research will allow you to learn what a file extension is as well as the function that it serves in the document that you are presently working on. This is a really simple plan to implement.
arrow_forward
Write Complete ASP.Net/C# code to
Store Your Own Image to the Database
Store a video clip to database
Display the contents of an Excel file in GridView (Showing your own FYP Group Member Details)
Export/Print the GridView contents to the PDF file (Rename the file with your RegNo)
arrow_forward
Hi All, Please help me with this question.
Employee Registry This project requires the use of an employees.dat file (create your own file). The record format in the file is listed below (separated by a single space): first_name last_name employee_id phone_number Overview You’ve been asked by your employer to create an employee registry program. The program will be used by the HR department to maintain employee records. Requirements When your program starts, it should read the employees.dat file into memory. A menu should be displayed like below. List all employee details List employee by last name Add a new employee Remove an employee Show all managers only Show all staff only Quit Each menu option should be handled by its own function. You should add utility functions as needed. When option 1 is selected your program should list all the information for each employee in a tabular format. When option 2 is selected your program should prompt the user to enter an employee’s last name. If…
arrow_forward
Task Performance
Student List
Objective:
At the end of the exercise, the students should be able to:
• Map values in Java and Python.
Software Requirements:
• NetBeans IDE
Java Development Kit (JDK) 8
Python 3.7 or higher
Procedure:
1. Create a folder named LastName_FirstName in your local drive. (ex. Reyes_Mark)
2. Using NetBeans, create a Java project named StudentList. Set the project location to your own
folder.
3. Import Scanner, Map, and HashMap from the java.util package.
4. Create an empty hash map named students.
5. The output shall:
5.1. Ask three (3) of your classmates to enter their student number (key) and first name (value).
5.2. Display the keys and values of the map.
5.3. Delete the mapping of the third entry.
arrow_forward
PROGRAM WORKFLOW:
The program is intended to serve as a visitor logbook, which is necessary for keeping track of who comes to the site. Users will be asked to enter their name, contact information (email or phone number), the purpose of their visit, and the time they enter the site when they first arrive. To keep track of the information, the data will be saved in a separate file. When the user exits the site, they will be asked to enter their departure time once more. The records stored can then be accessed at the end of working hours.
// Please take time to follow the program workflow. Thank you for help me out.
arrow_forward
Please help me
arrow_forward
Please help me
arrow_forward
Please help me
arrow_forward
Process Activity
Create a program(forkchildren.c) that will fork off two children.
One child will run the “ls -l” command.
The other will run “cat forkchildren.c”.
The main program will wait for the children to finish and then print a note saying it is finished and then it will end.
No pipe is needed for this assignment, each child is separate.
arrow_forward
Project: Blood Donation System
The blood donation center is responsible for managing the donations process as it is received
from the donor until it is sent to the distribution office.
First the blood center worker will enter the donor's general information like name and
birthdate then the system will create an account for the donor and generate an id if it was the
first donation by the donor. Next, the donor will give the donation and the worker will create a
new record of the donation in the system by entering the donor's ID. Then the donation will be
sent to a testing unit. The testing unit will conduct tests on the donation and sends the blood
donation along with test results to the processing office, which will fill a form for the donation
if they pass the test and finally sends the blood units and forms to the distribution office. If
the donation failed the test, the processing office will destroy the donation and will notify the
worker. Please note that the donor must at least…
arrow_forward
This article will offer an explanation of file extensions and the apps
that generate them. It is critical to have examples.
arrow_forward
Before you use a file extension, be sure you understand what it is and what role it performs in the context of your task.
arrow_forward
Write the Java statement to create an instance of a Rectangle with a width of 4 and a length of 8.
Edit View Insert Format Tools Table
arrow_forward
Each member in a group, create a directory (with your studentID) then create a file (.txt) with your first name, in the file, add text to tell your full name and describe in one line your short goal in this term as a student. Then, display the file content. Finally, rename the file (first nameGoal). You MUST have screenshots for the task and all steps (the commands and outputs).
arrow_forward
8
File
Help
Tell me what you want to do
Home Insert Design Layout References Mailings Review View
iGET GENUINE OFFICE Your license isn't genuine, and you may be a victim of software counterfeiting. Avoid interruption and keep your files safe with genuine Office today.
Page 1 of 1
80 words
Accessibility: Investigate
CS309
CS309 ASSIGNMENT 9 - Word
A process description for "Pay Commission" is provided below:
For each COMMISSION EARNED
If EXTRA BONUS equals Y
|
-If PAYMENT TOTAL is greater than $80,000
Add 3% to COMMISSION PERCENT
Output SPECIAL LETTER
Output AWARD LIST
Else Add 2% to COMMISSION PERCENT
Output AWARD LIST
Else
If PAYMENT TOTAL is greater than $80,000
Add 1% to COMMISSION PERCENT
Output SPECIAL LETTER
Calculate COMMISSION COMMISSION PERCENT times PAYMENT TOTAL
Required:
Construct a Decision Table for the above process description.
delinki asylum
Get genuine Office
Learn more
F
+
+
X Q
X
100%
arrow_forward
Mt noy Modify the Octave script that you wrote for Task 1 to generate the
following figure. It may look difficult at first, but if you really understand the code
that you wrote for Task 1, it shouldn't be that difficult to generate the figure
below.
arrow_forward
INSTRUCTIONS
• Create a project, create a VI and Design the logic circuits below.
You can create all the circuits in one VI.
When done, use the save all function to save the project and the VI.
Zip (not RAR) and save the files under your ID and name e.g.
10448989_Matthew_Fiifi_Hayford.zip.
1. F(X, Y, Z) = X + YZ
Design the logic diagram below and simulate. Ensure that you get the output as shown in the
truth table.
X Y Z X+YZ or F
000
001
010
011
100
101
11
111
1
Y
1
1
1
> N
arrow_forward
This piece will define file extensions and identify the programs that generate them. Some concrete examples would be helpful.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Related Questions
- Part 1) Open up Assignment 5 Original file from the Canvas Assignment, and save it to your local computer. Click on the Problem 1 worksheet. What is the spreadsheet telling you? If there is a problem, what is the problem? If there is a problem, where is the problem and what can you do about it, e.g. how would it be fixed?arrow_forwardUpload answer sheets Define step by step algorithm for the previous question. Explain the flow of the program in your own terms, especially, when control goes to function 2 from main method, not more than two pages. Once you upload files from your second device, click on Sync to check your submissionarrow_forwardBlackboard Submission Instructions: 1. Group Assignment Submission Link is located in the assessment section on blackboard. 2. Include the group members names as a comment at the top of the source code. e.g. // Eman Alyahyan 3. Upload program source files OR copy the source codes into a ( .txt ) files. 4. Upload screenshots of programs' outputs. Problem: (5 Marks) There are two scientists working on set of numbers. The first person is looking for two numbers specifically. The second person is responsible for entering all data. Help the first person to know if the numbers set entered by the second person includes the two numbers he is looking for! Input The first person shall enter two numbers. The second person enters set of numbers of any size. S/he can enter any range of numbers (up to you how to read those numbers). Output Message showing if both numbers entered by the first person have been found or not. If one of the numbers was found show which one has been found. Hint: you may…arrow_forward
- A-List Objective: At the end of the exercise, the students should be able to: ▪ Create an adjacency list in Java. Software Requirements: ▪ NetBeans IDE Java Development Kit (JDK) 8 Procedure: 1. Create a folder named LastName_FirstName in your local drive. (ex. Reyes_Mark) 2. Using NetBeans, create a Java project named AdjacencyList. Set the project location to your own folder. 3. Create an adjacency list based on the given graph. B A с E D F Garrow_forwardWeek 4 IPO Assignment Content There are 4question Create IPO chart q1. When Trina began her trip from New York to Florida, she filled her car's tank with gas and reset its trip meter to zero. After traveling 324 miles, Trina stopped at a gas station to refuel; the gas tank required 17 gallons.arrow_forwardCode Listing to shows the template for the build process.arrow_forward
- For the below code I need to add a history list with below conditions, Objectives Extend the functionali of the the calculator to save and display the past results of the arithmetic operations Stage 2: Save and display calculation history of the calculator In this second stage of the assignment you will extend the given calculator program to record the calculations, and recall them as a list using an additional command '?'. Task 1: Study the given code in the answer box and extend it to save each executed operation in a Python List. Declare a list to store the previous operations Save the operator, operands and the results as a single string, for each operation after each calculation Task 2: implement a history() function to handle the operation '?' Display the complete saved list of operations (in the order of execution) using a new command ‘?’ If there are no previous calculations when the history '?' command is used, you can display the following message…arrow_forwardIt would be helpful if you could provide a suggestion to enhance the way a file is organized.arrow_forwardLab Assignment 2: Playfair Cipher Overview: You are required to use the Playfair cipher to encrypt the message: "Butch." You will do the encryption by hand. The key for encryption is “Govern." You will need to show your work for the encryption process. Your submission should be a typed text filearrow_forward
- Sequence Diagram for the use case text below: Basic Course The student views the Grad Check Home Page and clicks on the Edit Schedule button. The system then displays the Current Student Schedule. On this page, the student may then choose a course to delete a course or to add a course. After the student performs these tasks, the system asks the user to save the changes on the Save Changes page. If the student selects Yes, the system updates the student record file. Otherwise, the student record is not updated. Alternate Course The student record file is unavailable: display Unable to Save page to the Student.arrow_forwardDoing some research will allow you to learn what a file extension is as well as the function that it serves in the document that you are presently working on. This is a really simple plan to implement.arrow_forwardWrite Complete ASP.Net/C# code to Store Your Own Image to the Database Store a video clip to database Display the contents of an Excel file in GridView (Showing your own FYP Group Member Details) Export/Print the GridView contents to the PDF file (Rename the file with your RegNo)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Programming Logic & Design ComprehensiveComputer ScienceISBN:9781337669405Author:FARRELLPublisher:CengageNp Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage