dbms homework help

Boost your journey with 24/7 access to skilled experts, offering unmatched dbms homework help

Trusted by 1.1 M+ Happy Students

4.3Trust Pilot

4.4Edu Reviewer

4.5App Review

4.5Student

WhatsApp Support

Get Instant
Online Homework Help
via WhatsApp

Get instant homework help from top tutors—just a WhatsApp message away. 24/7 hw help support for all your academic needs!

★★★★★

2M+ students trust TutorBin

Your WhatsApp Number

⚡ Instant reply

🔒 100% private

👨‍🏫 Top tutors

🌍 All subjects

^*Get instant homework help from top tutors—just a WhatsApp message away. 24/7 support for all your academic needs!

2M+ Students Helped24/7 Live SupportExpert TutorsAll Subjects CoveredInstant Response100% ConfidentialTop Rated ServiceMoney-back Guarantee2M+ Students Helped24/7 Live SupportExpert TutorsAll Subjects CoveredInstant Response100% ConfidentialTop Rated ServiceMoney-back Guarantee

Recently Asked dbms Questions

Expert help when you need it

Q1:Replace the function created above with one that uses regular expressions. Look into regexp-instr and regexp_replace.See Answer
Q2:WHAT ARE YOU REQUIRED TO DO? 1. Develop a conceptual data model based on the above Narrative. You may use the Chen's notation, the Crow-feet notation, or the Unified Modeling Language notation to present the conceptual data model. A summary of steps for developing the conceptual data model is given here: a. Identify entities, their associated attributes, and primary key attribute(s). b. Identify the relationships between entities and the associated relationship attributes and cardinality (including multiplicity and participation constraints). c. Produce an Entity-Relationship Diagram depicting the conceptual data model. 2. Produce a logical data model from the conceptual data model you have developed in (1). A summary of steps for developing the logical data model is given here: a. Transform the Entity-Relationship Diagram into relational schemas (1.e., tables). b. Refine the relational schemas by combining schemas and normalizing the tables where necessary to produce the final logical data model. 3. Present the conceptual data model and logical data model in a Powerpoint presentation file. 4. Submit the Powerpoint presentation file.See Answer
Q3:PART 1: Before you begin developing the actual database, you need to do a bit of research. Database administrators today continually research customer’s needs when designing and developing a database. This activity will help prepare you to conduct this type of research. You will compose an essay that fulfills the following requirements: Define the terms database, table, record, field, and value and describe the hierarchy that exists between these terms. Demonstrate knowledge of a relational database. Your goal is to demonstrate that you understand what a relational database is. Describe the six database objects available in Microsoft Access. Describe the five-step design method discussed in your reading. The paper must be written in your own words. You are encouraged to read the assigned readings first to gain valuable insight for your paper. See Answer
Q4: (25%) List the candidate keys and the highest normal forms for the following(2)relations. [a] R(A,B,C,D) {C->AD} [b] R(A,B,C,D) {C->A, A->BD} [c] R(A,B,C,D) {C->A, A->C, AC->B, B->D, D->B} [d] R(A,B,C,D) {С->А, А->, АС->BD} [e] R(A,B,C,D) {C->B, BD->AC}See Answer
Q5: meaning that the tutor with id 't1' and name 'Jenny Jackson is assigned as the tutorfor the student with id 's101' and name 'Steve Adams' on the subject 'Physics' (withthe subject id 'sub101') starting on 2019-01-11 at Level 4.See Answer
Q6:Queries 7.) Group-By: Create a query that shows the CookieName, and total Quantity sold for cookies with a total quantity of more than 10 boxes. Save the query as CookieCount (5) 8.) Group-By: Create a query that shows the CustomerID, FirstName, CookieName and total Quantity for all orders with "Lemonade" cookies in them. Save the query as LemonadeOrders. (5) (Hint: "Lemonade" is a specific name) 9.) Group-By: Create a Query that shows OrderID, CookieName, total Quantity, Price and a new field named "Line Total" that calculates the Quantity*Price for line items. Name it Sales. (5) (Hint: This is similar to query # 14 that used the Date Diff() function, however you do not need a function for this query. Just a simple multiplication.) 10.) Create an Update query that increases the price of all cookies by $1. Name the Query Price Update (5)See Answer
Q7:1. A detailed schema using the ER model including: • Design a corresponding set of tables that are in at least 3NF. • List of the attributes for each entity and relationship. • Explanations of the non-obvious entities and relationships. 2. Provide DDL including: CREATE tables. 3. Construct the following queries and provide results: A) Populate (INSERT Statements) tables with some data. B) Show customer details i.e., customer information and address (pick any)? C) Show all Products that are below 50 quantity. D) Show all orders of a customer (pick any)?See Answer
Q8:The third part of the project is to load some data into the database and apply certain update transactions and retrieval queries. You will create your own data that needs to be sizable. For transactions, create a user friendly interface to enter the information needed by the transaction. This can either be a Web-based interface, a command line interface, or a forms interfaceSee Answer
Q9:COMPETENCY ASSESSMENT Introduction Assessment Rubric and Minimum Submission Requirements This competency assessment assesses the following Outcome(s): IT163-5: Construct reports to retrieve data. Module Outcomes: • Examine the report options in Microsoft Access. • Create a report using Microsoft Access. See Answer
Q10:3. Functional Dependencies Consider relation R (A, B, C, D, E) with the following set of F.Ds: FD1 = {A →B, AB→C, D→AC, D →E} FD2= {A→BC, D →AE} Determine if FD1 is equivalent to FD2See Answer
Q11:3. Functional Dependencies Consider relation R (A, B, C, D, E) with the following set of F.Ds: FD1 = {A →B, AB→C, D→AC, D →E} FD2= {A→BC, D →AE} Determine if FD1 is equivalent to FD2See Answer
Q12:To work on their projects, each student group (who sit in numbered tables, as described in HW1) can also (in addition to working at those numbered tables) reserve one of ten available rooms to work on their project. The rooms can be reserved for a block of a few hours (eg. 3 hours), with a start time and end time, eg. 3pm-6pm. 9am-2pm etc. At the end of the day, everyone goes home, so there's no possibility of rooms being booked for multiple days. The table structure you are asked to use, is this [you might need to change the syntax slightly, to make it work on your specific platform - same for other questions that follow]: CREATE TABLE ProjectRoomBookings (roomNum INTEGER NOT NULL, startTime INTEGER NOT NULL, endTime INTEGER NOT NULL, groupName CHAR(10) NOT NULL, PRIMARY KEY (roomNum, startTime)); There are two issues with the above. First, the start time could be incorrectly entered to be later than the end time. Second, a new entry (for a new group) could be accidentally put in to occupy a room, even before the existing group in that room is done using that room. For simplicity, you can express times in the 24h military-style format, eg. 9 for 9AM, 17 for 5PM, etc. For further simplicity, all bookings start and end 'on the hour', so, ints between 7 (7AM) and 18 (6PM) should be sufficient. How would you redesign the table to fix both these issues? For your answer, you can either provide a textual explanation, and/or provide SQL statements. Hint - "do not be concerned with efficiency" - ANY working solution is acceptable :) Another hint - no need to learn new techniques/syntax.See Answer
Q13:The owners decide to reward instructors with a bonus, at the end of the term. The bonus (a one-time payout) is calculated, like so: bonus = hourly_rate * sum_of_class_counts * 0.1 'sum_of_class_counts' is simply a total, of student count from each class an instructor taught - eg. if instructor Dat taught JavaScript, Python and Scratch, with enrollments of 20, 20 and 15 students respectively, the sum_of_class_counts for Dat will be 55 (if a student takes multiple courses - we count that student as many times, not count them as 1). Also, this bonus is just for teaching, not for supervising projects. Write a query that will output the highest bonus amount paid. Do feel free to create whatever table(s) you need, and populate it/them with your own data.See Answer
Q14:3. MENU RECOMMENDATION (Part 1: Meal Type) First create 4 records in the MC_90_DAYS_MEAL_TYPE table completing the INSERT statements below. You MUST assign a specific PK value to each record. However, all your queries MUST NOT assume those IDs in any circumstances. I will test your queries in my own data, and you will NOT know which MEAL_TYPE_ID I used to create each record, i.e., all filters and condition in queries MUST use the MEAL_TYPE_NAME column. INSERT INTO MC_90_DAYS_MEAL_TYPE (MEAL_TYPE_ID, MEAL_TYPE_NAME) VALUES ( 'Breakfast'); I INSERT INTO MC_90_DAYS_MEAL_TYPE (MEAL_TYPE_ID, MEAL_TYPE_NAME) VALUES ( 'Lunch '); INSERT INTO MC_90_DAYS_MEAL_TYPE (MEAL_TYPE_ID, MEAL_TYPE_NAME) VALUES ( 'Afternoon snack'); INSERT INTO MC_90_DAYS_MEAL_TYPE (MEAL_TYPE_ID, MEAL_TYPE_NAME) VALUES ( 'Dinner'); COMMIT; I I ISee Answer
Q15:2. Write down the SQL to show the unique department_id in the employees table. (Hint: 12 records)See Answer
Q16:4. Write down the SQL to show the first name and last name for those employees satisfying one of the following conditions (1) hire_date is after 01/01/2008 and before 12/31/2008, (2) salary is above 8000. (Hint: 43 records, and I am asking you to write one SQL for this question instead of two.)See Answer
Q17:PART 2: Smart Products / Services Definition: A smart product is an entity designed for self-organized embedding in the course of its lifecycle. A smart service generally implies a smart product and vice versa. For example, the Moroccan police department has introduced fixed radars which can be considered as a smart product. A smart service could be the website: (https://infractionsroutieres.narsa.gov.ma/InfractionsRoutieres/app/accueil) where citizens can check for their traffic violations. Think of an example of challenges that a business (new or existing one) might encounter and how to overcome them introducing a new service or product? Questions you may answer on your term paper: Why should companies build smart products and smart services? What benefits can the business gain? Provide several examples of new products or services you may introduce. What are some limitations of a smart products/services strategy? (A one-page paper might be sufficient for this essay)See Answer
Q18:Individual Exercise 1 a) Specify the following queries in SQL on the database schema of Figure 1.2. a. Retrieve the name of each course and the instructor who taught that course. If an instructor taught a course more than one time, remove the redundant information. b. For each section of those courses offered by CS department, retrieve the course number, semester, year, and number of students who took the section. c. For each student who took more than 2 sections, retrieve the name, student number, major of the student and the number of sections taken by the student. STUDENT COURSE SECTION Smith Brown Course_name Intro to Computer Science Data Structures Name Discrete Mathematics Database GRADE REPORT PREREQUISITE Section identifier 85 92 102 112 119 135 Student_number 17 8 Course_number CS1310 Course_number MATH2410 CS1310 17 17 CS3320 MATH2410 CS3380 CS3320 MATH2410 CS1310 CS3380 Student number 8 8 8 8 Course_number CS3380 CS3380 CS3320 Class 1 2 Credit hours Semester Fall Fall Spring Fall Fall Fall 4 4 3 3 Section_identifier 112 119 85 92 102 135 Major CS CS MATH2410 CS1310 Figure 1.2 Example of a simple database Year 07 Prerequisite_number CS3320 07 08 08 08 08 Department CS CS MATH CS Instructor King Anderson Knuth Chang Anderson Stone Grade B с A A B ASee Answer
Q19:Instructions 1. Building and Populating the Schema (9 marks) Develop a database in Oracle to implement the Erehwon Bank scenario. Code the SQL DDL to build all the tables, complete with constraints and default values (except for lookup of the Ref_Nbr for a Transaction... that will require procedural code in step 4). Choose appropriate data types for each of the columns. Add those indexes that you believe would be useful. Include comments in your SQL script(s) to document any decisions you made. Populate your database with the test data. • In your SQL INSERT statements, you must make use of sequences for generating key values for the Client, Account, and Transaction tables. • You must use the TO_DATE function to get proper date and time values for the transactions. Note that trigger code to be written in step 4 will be used to validate a Transaction Ref Nbr against either a Bank Nbr or Merchant Nbr as well as update the account balance according to the type and amount of the transaction. The test data already has entries for the Owns and Transaction INSERTS that should be rejected due to invalid FK lookups. Take a screen shot of running those scripts to show that is the case. It is not required to demonstrate NOT NULL constraints. 2. Views (4 marks) To facilitate queries, three views are required. Submit your SQL script(s) as well as a SELECT * FROM... listing of each view. Join of Transaction to Type description (1 mark) Join of Client to Account via the Owns table, containing the client's number, name, the account number, and balance. (1 mark) (Hint: Use an outer join as one client has no accounts.) • Join of Deposit and Withdraw transactions to Bank Branch UNION with join of Bill Payment and Debit Purchase, or Return transactions to Merchant (i.e., all transactions with appropriate reference name.) (2 marks)See Answer
Q20:Q1: The CEO of AdventureWorks Inc. wants to build a data mart to keep track of product production inventory. He is concerned with how effective each product vendor provides the company appropriate products. To measure the effectiveness of each product vendor, he wants to use total numbers of work order quantity and total number of work order scrapped quantity. Provide a 4-steps dimensional model in the SQL comment section (1 points) and create a data mart solution in SQL for the dimension model that you propose (2 points).See Answer

TutorBin Testimonials

I found TutorBin Dbms homework help when I was struggling with complex concepts. Experts provided step-wise explanations and examples to help me understand concepts clearly.

Rick Jordon

TutorBin experts resolve your doubts without making you wait for long. Their experts are responsive & available 24/7 whenever you need Dbms subject guidance.

Andrea Jacobs

I trust TutorBin for assisting me in completing Dbms assignments with quality and 100% accuracy. Experts are polite, listen to my problems, and have extensive experience in their domain.

Lilian King

I got my Dbms homework done on time. My assignment is proofread and edited by professionals. Got zero plagiarism as experts developed my assignment from scratch. Feel relieved and super excited.

Joey Dip

Popular Subjects for dbms

You can get the best rated step-by-step problem explanations from 65000+ expert tutors by ordering TutorBin dbms homework help.

TutorBin helping students around the globe

TutorBin believes that distance should never be a barrier to learning. Over 500000+ orders and 100000+ happy customers explain TutorBin has become the name that keeps learning fun in the UK, USA, Canada, Australia, Singapore, and UAE.