Database - Interview Questions and Answers for 'Database schema' | Search Interview Question

Database - Interview Questions and Answers for 'Database schema' - 3 question(s) found - Order By Rating

Q1. How would you design the database schema for an event?

Ans. Broad question, but if the company need velocity, think about use a NO SQL instead of regular SQL databases.

Also prefers materialized views instead of joins to fetch data quickly.

Regarding the database design, there are very good design tools for professional database (to develop proper indexes and good database design) one of the best is QuickDBD

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve database design database schema Asked in 1 Companies}

Related Questions

Design a Database Schema to store Employee Information with each employee having multiple addresses.

Design database schema for Facebook like application.

Create DB schema for Employee, Department.

Q2. Create DB schema for Employee, Department.

Database

^{This question was recently asked at 'RiseSmart India,RiseSmart'.This question is still unanswered. Can you please provide an answer.}

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve db schema database schema database design Asked in 2 Companies}

Related Questions

Design a Database Schema to store Employee Information with each employee having multiple addresses.

Design database schema for Facebook like application.

How would you design the database schema for an event?

Q3. Design a Database Schema to store Employee Information with each employee having multiple addresses.

Database

Ans. We can have 2 entities i.e EMPLOYEE and ADDRESS and can have a relationship Table , EMPLOYEE_ADDRESS having one to may relationship between the two.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve database schema design Asked in 2 Companies}

Related Questions

Design database schema for Facebook like application.

Create DB schema for Employee, Department.

How would you design the database schema for an event?

Search Interview Questions

Help us and Others Improve. Please let us know the questions asked in any of your previous interview.