Database - Interview Questions and Answers for 'Database design' - 3 question(s) found - Order By Newest Q1. Design database schema for Facebook like application. Database
This question was recently asked at 'Symantec'.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  database design Asked in 1 Companies expert Related Questions Difference between == and .equals() ? Why is String immutable in Java ? Explain the scenerios to choose between String , StringBuilder and StringBuffer ?
or
What is the difference between String , StringBuilder and StringBuffer ? What are the difference between composition and inheritance in Java? What is a Lambda Expression ? What's its use ? Does garbage collection guarantee that a program will not run out of memory? Why Char array is preferred over String for storing password? Explain OOPs
or
Explain OOPs Principles
or
Explain OOPs Concepts
or
Explain OOPs features
or
Tell me something about OOPs What are different ways to create String Object? Explain. What is the difference between Encapsulation and Abstraction? 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. How would you design the database schema for an event? Database
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.