Databases | SQL | Oracle | MS Access Answers

In a University , there are several departments and each department has a head of department who belongs to Faculty. Department have a name , phone extension , specific mailing address and Students that belong to the department. Students can belong to only one Department at a time and Department can have more than one or no Student

Students and faculty have names and unique identification numbers , with address , age , gender and other information. Student studies different Courses offered by University . Faculty teaches these Courses . In each semester one student can take more than one course and Faculty can teach more than one courses . Faculty members can teach in multiple Departments. Each course can be taught by many faculty members or no one Faculty members are also working on multiple research projects. These projects are funded by government and university. One project can have more than one faculty member and one faculty member can work on more than one project

Draw ER diagram

Case study:

The owners of a small computer repair shop would like to keep track of the repair jobs for computers they repair, the items used for each repair job, the labor costs for each repair job, the repairmen performing each repair job, and the total cost of each repair job.

When customers bring their computers in to be repaired, they make a deposit on the repair job and are given a date to return and uplift their computer. Repairmen then perform repairs on the customers’ computers based on the repair job, and detail the labor costs and the items used for each repair job.

When customers return they pay the total cost of the repair job less the deposit, collect a receipt for their payment, and uplift the repaired computer using this payment receipt.

Find the entity and attributes and also draw an ER Diagram of this case

Draw an Entity Relationship Diagram (ERD) using Unified Modelling Language (UML) notation, representing these business rules. Your design should be at the logical level – include surrogate primary key and foreign key fields and remember to remove any many-to-many relationships.

1.A launchpad hosts multiple launches over time, and each launch is hosted by exactly one launchpad. Launchpads will be created in the database even before the first launch is hosted there.

2. A launchpad is located in a country, and a country in turn is located on a continent.

3. Each launchpad has a name and a location.

4. A launch requires three things: a launchpad that hosts it, a launch vehicle (the rocket), and the payload.

5. For a launch, the date, time and name should be recorded as well as whether it is a crewed launch or not

Find the bandwidth for the following situations if we need to modulate a 5-KHz voice.

a. AM

b. PM (setß=3)

c. PM (set p=1)

Compare the telephone network and the Internet. What are the similarities? What are the

differences?

the evolution of data models

1. a) A program has 200 instructions and runs in a processor in 5 ns. If each of the instructions take

10 clock cycles, what is the value of Clock Cycle Time?

b)A program has 125 instructions and total clock cycles consumed by the program is 31.25 ms.

What is the value of cock per instruction?

Explain the limitation of PCI bus sharing

Explain why PCI performs better than EISA and VL-Bus

Get the top 3 genre_ids that are liked by the users in India in the year 2018.

Note:

• Consider the name of the country as "INDIA"
• Consider reaction_type LIKE as liked. If a video belongs to 3 genres, then the like is counted in all the 3 genres.
• Sort the output in the descending order of no_of_likes, and then in the ascending order of the genre_id.

Expected Output Format

genre_id no_of_likes

... ...