Describe what entity represents in an er mode

Assignment Help Database Management System
Reference no: EM13779308

1- What is a database?

2- Data ( ) language is used by the DBA to define schemas.

3- Please describe the three-tier client/server architecture for web applications

4- Give example of system in which it may make sense to use traditional file processing instead of a database approach.

5- Describe what entity represents in an ER mode and provide examples of entities with a physical or conceptual existence.

6- Describe how strong and weak entities differ and provide an example of each.

7- You are required to create a conceptual data model of the data requirement for a company that specializes in IT training. The company has 30 instructors and can handle up to 100 trainees per training session. The company offers five advanced technology courses, each of which is taught by a teaching team of two or more instructors. Each instructor is assigned to a maximum of two teaching teams or may be assigned to do research. Each trainee undertakes one advanced technology course per training session.

(a) Identify the main entity types for the company.

(B) Identify the main relationship types and specify the multiplicity foe each relationship. State any assumptions you make about the data.

(C) Using your answers for (a) and (B), draw a single ER diagram to repressor the data requirement for the company.

8- what is a mission statement?

9- Discuss Tow Limitations of the file-based approach.

10- discuss tow characteristics of the database approach.

11- Describe the purpose of normalization. What are the normalization processes and what happens n each step of the process?

12. Explain the function of each of the clauses in The SELECT statement.

FROM: Specifies the table or tables to be used

WHERE: Filters the rows subject to some condition

GROUP BY: Forms groups of rows with same column name

HAVING: Filters the groups subject to some condition

SELECT: Specifies which columns are to appear in the output

ORDER BY: Specifies the order of the output.

Use the figure above to write a relational algebra expression for the following questions.

13. Retrieve the birthdate and address of the employee(s) whose name -John B. Smith.

14. Retrieve the average salary of all female employees.

15. Retrieve the names of all employees who do not have supervisors.

Reference no: EM13779308

Design and implement database for real world environment

In this project option, you are asked to design and implement a database for a real mini world environment based on the given database requirements written in natural langua

Design a database - what is the purpose of your database

Design a database, a database planner should spend a considerable amount of time thinking about what kind of information will be included in the database and how it will be

Describe how indexing fields could be beneficial

The current TAL Distributors database only has a few customers; however, in reality, such a database would likely have records for thousands or hundreds of thousands of cust

Construct a relational schema for the er-diagram

Construct a relational schema for the ER-diagram. Make sure that you correctly translate Specialization and Many-to-Many relationships. Please follow carefully the following

Effectiveness of classic models and recently evolved models

Compare and contrast the effectiveness of classic models and recently evolved models such as Big Data and NoSQL. Give your opinion on which type of model is more effective and

Write a query using the books and publisher tables

Write a query using the BOOKS and PUBLISHER tables that will show all of the publishers' names and related book titles, even those publishers who do not currently have any b

Build a gantt chart using microsoft project

Discuss what it will take to build a Web architecture, move an existing Website with minimal downtime, and provide a disaster recovery solution to ensure the site is always

Database design and sql queries

In assignment 1, you have already started the process of designing a database for the Beauty Salon mini-case (enclosed again below), mainly in the phase of conceptual database

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd