FIGURE P1.11 STUDENT SCHEDULE DATA FORMAT STU_ID STU_ CLASS_ CLASS_ CLASS_ INSTR_ CLASS_ CLASS_ ROOM NAME CODE NAME CREDHRS NAME DAYS TIMES a) Create a spreadsheet using the template shown in Figure P1.11 and enter your current class schedule. b) Enter the class schedule of two of your classmates into the same spreadsheet. c) Discuss the redundancies and anomalies caused by this design.
Q: “An airliner can be assigned to fly many flights, but each flight is flown by only one airliner.”…
A: We need to model the given statement using the crow’s foot modelling technique and write the SQL…
Q: 1. function is responsible for consolidating the results produced by each of the Map()…
A: Reduce function takes the output of the Map task, i.e. the primary value pairs, and aggregates them…
Q: How do I get this flat list table into 1NF, 2NF and 3NF?
A: Normalization:Normalization is a process of dividing the tables by more than one idea into set of…
Q: Indexing Consider a relational database that consists of the relational tables created by the…
A: Index: It is associated with a table or table cluster, that can sometimes advance data access…
Q: Veterinarian Office Case: Part 4 The veterinarian office created a database to keep track of owner…
A: 1. Option B is the correct code because it will add the row and along with that the message of…
Q: 1. Create an Oracle table with a minimum of two varchar(2) fields (one should be a persons name), a…
A:
Q: Given the below list, “Record”, that includes 2 sub lists. The first includes the names, while the…
A: Record = [["Ali", "Mazen", "Fida", "Nader", "Majd"], ["Tutor", "IT", "Manager", "PR", "Clerk"]]Sal =…
Q: Create a BANASTHALI database and an Employee table with following attributes Employee Id, Employee…
A: The above given question is to create a data base and also create a data table in a relational data…
Q: róčédure: 1. Create a table named StudentGrade with the following columns and values. Set the…
A: --creating tablecreate table studentgrade(coursecode varchar(30),coursetitle varchar(30),units…
Q: Create the following table in your database with the following schema: Table: Departments Column…
A: Table creation syntax: CREATE TABLE TABLE_NAME( column_name1 data_type, column_name2 data_type,…
Q: While the datamodel design process was still underway, an enterprising accountant started putting…
A: Update Anomaly: It is a data inconsistency that results from data redundancy and a partial update.…
Q: Discuss briefly the monotonicity property
A: The Answer is
Q: 1. Create a database called book_store that has a table called books in which has (book_name,…
A: Given: Create a database called book_store that has a table called books in which has (book_name,…
Q: Course: Database *(SQL)* Please excute the given SQL script…
A: 1. Retrieve the flight number, departure and arrival airports of all British Airways. Query: SELECT…
Q: Data about the horses that have been awarded top places in events has already been captured in a…
A: first we need to find the FD of the data Place---->horse id , horse name , bread id , breed…
Q: e an MVC vweb application having the index view given below. Given ated from the model book having…
A: Note: Since you have not provided the language to write the code, I am using Java language to write…
Q: This is a simple list table of a company trying to keep track of employee assignment to company…
A: Actually, database is a used to stores the data.
Q: indicate the changes(using the shorthand representation)that you would need to make to the original…
A: ITEM_ID which is unique and primary key in ITEM table can act as a identifier for ITEM. Using…
Q: Create a new database and rename it with your name. Create a new table called "Courses". Set an…
A: 1. Create a database and rename Open Microsoft Access-> clicl on file-> click on save database…
Q: 1. Create a database. 2. Create two table of your own choice and make relation between them. 3.…
A: PART I :Backend This demonstration is using SQL Server /*create database*/create database…
Q: # Question 1 #Using the World database, in the city table, insert a new city for the Tasmania…
A: What is SQL: SQL is a language for interacting with databases. SQL is the standard language for…
Q: Referring to Appendix A below, code a MySQL statement to display the item number and name for all…
A: As I get from your question, you want to run and show different queries.
Q: These questions are based on Human Resources (HR) database given in site…
A: Answer is given below. import pandas as pd Question A. departments =…
Q: While the datamodel design process was still underway, an enterprising accountant started putting…
A: Update Anomaly :- It is a data inconsistency that results from data redundancy and a partial update.…
Q: Veterinarian Office Case: Part 5 The veterinarian office created a database to keep track of owner…
A: 1. Answer : Option a. ALTER TABLE OWNER ADD PRIMARY KEY(OWNER_ID) ADD CHECK(OWNER_STATE='NV') 2.…
Q: a) Choose a database application with which you are familiar. Design a schema and show a sample…
A: Given information, Given a schema diagram and sample database in Figure 1 and Figure 2. It is…
Q: The contact service uses in-memory data structures to support storing contacts (no database…
A: Java Language : Java is a class-based, object-oriented programming language that is designed to have…
Q: Question & V Saved Problem 4-7 will use the same database Let a database application be Model…
A: The answer is
Q: CUSTOMER PARENT ADT Data Operations Customer ID (preferably int, auto-generated) Name [1] Add…
A: #include<iostream>#include<string>#include<vector>#include<bits/stdc++.h>usi…
Q: Which of the following is the highest level in a hierarchy of data organization? A Field. B…
A: Here we will discuss about the hierarchy of data organization
Q: 2) Task 2 - Assume that you are working as a database administrator for XYZ Company. You are asked…
A: The complete answer is given below .
Q: Data about the horses that have been awarded top places in events has already been captured in a…
A: I will explain it in details,
Q: 115. The types of template dependencies are a. constraint generating templates b. tuple generating…
A: constraint generating templates and tuple generating templates are the types of template…
Q: 3. Database management systems branch(branch name, branch.city, assets) customer(customer_name,…
A: Creating Bank database tables using mysql The bank database schema has a combination of…
Q: 4-22. Benjamin Department Store (Data Validation Using a DBMS) The payroll department at the…
A: We have to create a table to store the given data with its appropriate datatype in a single table…
Q: manages 主宝 BilingRate PROJECT EMPLOYEE 04 ProjectiD 04 assigned to- EmpD EmpName 手 runs ProjectTtle…
A: The Answer is
Q: TASK 2 Design a database to store student personal details, module details, and assessment results…
A: Answer: I have done code and also I have attached code as well as code screenshot.
Q: Referring to Appendix A below, code a MySQL statement to display the sales order number and customer…
A: code a MySQL statement to display the sales order number and customer name for all sales orders.…
Q: Assignment 1. Create a database called book_store that has a table called books in which has…
A: Solution Given that 1 Create a Database called Book_store that has a table called Books. 2 Create…
Q: While the datamodel design process was still underway, an enterprising accountant started putting…
A: Here is the attributes which is partial and transitive dependencies in this data. CompanyName id…
Q: Create the Crow's Foot ERD corresponding to the schema above.
A: Entities are represented as a rectangle in crow's foot notation, with their name at the top. The…
Q: 5. The EMPLOYEES database has three tables : EMPLOYEE_DATA (EmployeeID, FirstName, LastName,…
A: The EMPLOYEES has three tables: EMPLOYEE_DATA (EmployeeID, FirstName, DateOfBirth, Gender, Level,…
Q: Consider the File Structure for the XYZ Company Project Management data given below. Then,…
A: Given: A File Structure for the XYZ Company Project Management data consisting of several fields.…
Q: 51. Physical Data Independence is ability to modify _____________ without causing application…
A: Please find the answer to the above question below:
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: a. List of colleges sorted by zip code. b. Access to information on a specific lecturer—their name,…
A: For performing the operations, the SQL queries are:
Q: A database at a college must support the following requirements: For a department, store its number…
A:
Using your school's student
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
- 2- Design a class diagram of a course registration system. Note: utilize various class relations: generalization, aggregation, composition, and association; the class diagram should include but not be limited to the following class names User, Student, Instructor, Admin, Course, LogonPage, AddPage, DropPage, ChangePage, PrintPage, QueryPage, CoursenfoDB, StudentInfoDB, InstructorinfoDB, AdmintnfoDB, and EntireDB.Veterinarian Office Case: Part 5 The veterinarian office created a database to keep track of owner and pet information. It also includes tracking appointments and treatments for each pet. Unfortunately, the veterinarian database was not created correctly and needs modification. Read the question and select the correct dropdown to answer the question. Owner OWNER_ID OWNER_FNAME OWNER_LNAME OWNER_ST_ADDRESS OWNER_CITY OWNER_STATE OWNERE_POSTAL_CODE OWNER_PHONE OWNER_EMAIL 1 Melissa Canton NULL NULL NV NULL NULL NULL 2 Clay Sheperd Lousetown Road VC Highlands NV 89521 3456789 chsep@gmail.com 3 Helen Harvey 345 Pine Road Reno NV 89521 3451234 hharvey@gmail.com 4 April Windon 123 Doughton Road Reno NV 89521 3454879 awindon@gmail.com 5 Emily Minden 540 Fandango Pass Road VC Highlands NV 89521 3455190 emindn@gmail.com Pet PET_ID PET_BREED PET_NAME OWNER_ID…2- Design a class diagram of a course registration system. Note: utilize various class relations: generalization, aggregation, composition, and association; the class diagram should include but not be limited 10 the following class names User, Student, Instructor, Admin, Course, LogonPage, AddPage, DropPage, ChangePage, PrintPage, QueryPage, CourselnfoDB, StudentinfoDB, InstructorinfoDB, AdminlnfoDB, and EntireDB.
- Veterinarian Office Case: Part 4 The veterinarian office created a database to keep track of owner and pet information. It also includes tracking appointments and treatments for each pet. Unfortunately, the veterinarian database was not created correctly and needs modification. Read the question and select the correct dropdown to answer the question. Owner OWNER_ID OWNER_FNAME OWNER_LNAME OWNER_ST_ADDRESS OWNER_CITY OWNER_STATE OWNERE_POSTAL_CODE OWNER_PHONE OWNER_EMAIL 1 Melissa Canton NULL NULL NV NULL NULL NULL 2 Clay Sheperd Lousetown Road VC Highlands NV 89521 3456789 chsep@gmail.com 3 Helen Harvey 345 Pine Road Reno NV 89521 3451234 hharvey@gmail.com 4 April Windon 123 Doughton Road Reno NV 89521 3454879 awindon@gmail.com 5 Emily Minden 540 Fandango Pass Road VC Highlands NV 89521 3455190 emindn@gmail.com Pet PET_ID PET_BREED PET_NAME OWNER_ID…Task 2: Secondary Index & Aggregation Query Processing Assume the relation CITIZEN(ID, Tax-Code, Salary, Age) storing information about UK citizens’ tax codes and annual salaries. There are r = 60,000,000 records. Each attribute has the same size: 128 bytes. The relation is stored in a file sorted by the salary attribute. The block size B = 1024 bytes and any pointer in the system has size = 128 bytes. The salary attribute is assumed to be uniformly distributed across tuples. There are 6,000 distinct salary values and there are 10,000 different tax-code values. The tax-code and age are assumed to be statistically independent of salary. A data scientist, who has built a Secondary Index over the Tax Code (non- ordering, non-key attribute), is interested in the specific Tax Code: ‘1234L’. The data scientist did analyse the distribution of the Tax Code attribute and noted the following: • Let X be the number of citizens with Tax Code 1234L per data block. That is, given a random…PHP According to table the in the image 1. (Assume that the following program section (Program Code 1) are variables that receives input from the user via a form. Build program code to provide instructions for entering the data into the assessments table. In addition, next build a link to view the data that has been entered.) <?php include ('config.php'); $ matrixnum = $_POST['matrixnum']; $ subject_code = $_POST['subject_code ']; $ quiz = $_POST['quiz']; $ assignment = $_POST['assignment']; $ project = $_POST['project']; $ total_marks= $_POST['total_marks']; $ grade = $_POST['grade']; Code program 1 2.(Based on the program section (Code Program 1), assume that the data wants to be updated by the user. Build program code to provide instructions for updating the data to the assessments table. In addition, build a link to view the updated data.)
- Q3:Design UML for the following set of requirements for a universitydatabase that is used keep track of student’s transcripts.1. The university keeps track of each student’s name, student number,social security number, current address and phone, permanentaddress and phone birthdate, sex, major department, minordepartment (if any), and degree program (B.A., B.S., Ph.D.). Bothstudent number and social security number have unique values foreach student.2. Each department is described by a name, department code, officenumber office phone, Both name end code have unique values foreach department3. Courses are described by a course name, course number, credithours and department. each course has one or more prerequisitecourse.4. Each section has an instructor, semester (spring) , year , course ,and section number. The section number is unique.5. A grade report needs to be printed out to display the studentnumber, the section and the numeric grade1. Consider the following relations:Student (snum: integer, sname: string, major: string, level: string, age: integer)Class (name: string, meets at: string, room: string, fid: integer)Enrolled (snum: integer, cname: string)Faculty (fid: integer, fname: string, deptid: integer)The meaning of these relations is straightforward; for example, Enrolled has onerecord per student-class pair such that the student is enrolled in the class. Level is atwo character code with 4 different values (example: Junior: A Level etc)Write the following queries in SQL. No duplicates should be printed in any of theanswers.i. Find the names of all Juniors (level = A Level) who are enrolled in a classtaught by Prof. Kwizeraii. ii. Find the names of all classes that either meet in room R128 or have five ormore Students enrolled.iii. Find the names of all students who are enrolled in two classes that meet atthe same time.Consider the following schema: Suppliers(sid: integer, sname: string, address: string)Parts(pid: integer, pname: string, color: string)Catalog(sid: integer, pid: integer, cost: real) The key fields are underlined, and the domain of each field is listed after the field name. Therefore sid is the key for Suppliers, pid is the key for Parts, and sid and pid together form the key for Catalog. The Catalog relation lists the prices charged for parts by Suppliers. Write the following queries in relational algebra, tuple relational calculus, and domain relational calculus: 1. Find the names of suppliers who supply some red part.2. Find the sids of suppliers who supply some red or green part.4. Find the sids of suppliers who supply some red part and some green part.5. Find the sids of suppliers who supply every part. Write the above in SQL queries.
- Subject: Database Topic: EERD -Based on the information given below, draw the conceptual EERD where you should include the enhanced features. [Using UML Design] You are required to design a database for a car championship. The requirements are as follows: In the championship, each car’s information such as the car model, the top speed and the acceleration will be stored, and it is identifiable through a unique car ID. Each car will be drove by only one driver. Each driver’s info such as the unique driver number, driver name and the experience level of the driver are stored as well. A driver may have many trainers from more experience drivers and these experience drivers would have at least one trainee who follow them. Each of these drivers are usually supported by a team which each team have a name and is identifiable through the team number. Usually, a team would have at least one driver in the race. Every race would have a specific race ID and a race name. In a race would consists of…Which of the studied data structures in this course would be the most appropriate choice for the following tasks? And Why? To be submitted through Turnitin. Maximum allowed similarity is 15%. A Traffic Department needs to keep a record of random 3000 new driving licenses. The main aim is to retrieve any license rapidly through the CPR Number. A limited memory space is available. A symbol table is an important data structure created and maintained by compilers in order to store information about the occurrence of various entities such as variable names, function names, objects, classes, interfaces, etc. Symbol table is used by both the analysis and the synthesis parts of a compiler to store the names of all entities in a structured form at one place, to verify if a variable has been declared, …etc.WEEK 8 ASSIGNMENT create a star schema for the Bob's Fixit Group Case Study . The star schema needs to support the analysis or measurement of material price by suppliers, date, and jobs. Case Study Bob owns a small company called Bob’s Home repairs. He does the small home repair jobs that the large companies pass by. Need some woodwork or wood furniture fixed? Call Bob. Here is how the business works: Someone calls Bob and asks him to bid on a job. He drives over, looks at the situation, and gives them a bid. Sometimes it is an official looking bid by mail, and sometimes it is scribbled on notebook paper. He decides how long it will take to do the job (he bills by the hour), how much wood will be needed, any odds and ends that are unique to the job, and an overall price. He moves from job to job and bills customers as he finishes the work. Bob buys items and supplies from a variety of places, but he buys stuff only when it is needed for a particular project. A potential problem:…