Recent questions tagged rdbms

0 votes

295 views

1 answer

rdbms - Normalization in database management system

I have a relation in a database: Emp_project(SSN,PNum,Hours,Ename,PName,Plocs) I have been asked to normalize the relation Emp_project. How do I normalize it? Question&Answers:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

411 views

1 answer

rdbms - How to detect duplicate rows in a SQL Server table?

What is the most efficient way to detect duplicates in a 10 column / 50K row table? I'm using MSSQL 8.0 ... /questions/306743/how-to-detect-duplicate-rows-in-a-sql-server-table...

asked Oct 6, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

373 views

1 answer

rdbms - How to detect duplicate rows in a SQL Server table?

What is the most efficient way to detect duplicates in a 10 column / 50K row table? I'm using MSSQL 8.0 ... /questions/306743/how-to-detect-duplicate-rows-in-a-sql-server-table...

asked Oct 6, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

494 views

1 answer

rdbms - 1. How many customers placed at least 1 order? 2. How many "Real Estate" customers placed an order?

I have created two tables: Orders: CustomerID OrderId OrderDate Revenue Industry: CustomerID Industry Now I want to write a query ... Please help me on this. I am new in coding....

asked Feb 19, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

515 views

1 answer

rdbms - may i know the best online entitiy relationship diagram tool?

I am going to face an exam for RDBMS; so, I need a good tool to draw ER diagrams. I am using windows pc, is there any free tools to do this?...

asked Feb 19, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags