35256: Relational Database and Management Systems Practical Computers 5th Sem Syllabus for Diploma TNDTE M Scheme

Relational Database and Management Systems Practical detail TNDTE Diploma syllabus for Computer Engineering (CS), M scheme is extracted from TNDTE official website and presented for diploma students. The course code (35256), and for exam duration, Teaching Hr/week, Practical Hr/week, Total Marks, internal marks, theory marks, duration and credits do visit complete sem subjects post given below. The syllabus PDFs can be downloaded from official website.

For all other computers 5th sem syllabus for diploma m scheme tndte you can visit Computers 5th Sem Syllabus for Diploma M Scheme TNDTE Subjects. The detail syllabus for relational database and management systems practical is as follows.

Rationale:

Objectives:

On completion subject, the students must be able to

• Define data , database , database Management systems and data base models.
• Compare file processing and database system.
• Study about architecture of DBMS.
• Understand the concept of Data warehousing , Big Data and client/Server Technology
• State CODD’s Rules.
• Explain normalization and explain different types of Normal Forms.
• Create Normalized Database structure files .
• Perform all database DDL, DML, DCL, and all related commands.
• Write Logical and Conditional statement for Database Query.
• Write procedures and functions .
• Create and use Triggers.
• Understanding Data warehousing & Introduction to Big data and NoSQL

Part – A

For complete syllabus and results, class timetable and more pls download iStudy Syllabus App. It’s a lightweight, easy to use, no images, no pdfs platform to make students life easier.

Part – B

1. Create a table to store the details of a customer in a Bank. Do some transactions like withdrawal, deposit. Find the Balance amount(Credit Limit). Based on customer’s credit limit, write a program using IF or CASE flow control statements to find the customer levels namely SILVER, GOLD or PLATINUM.

If the Credit limit is

• greater than 50K, then the customer level is PLATINUM
• less than 50K and greater than 10K, then the customer level is GOLD
• less than 10K, then the customer level is SILVER
2. Create two tables with the following structure.
1. users – table name

user_id – UNSIGNED, INT, AUTO INCREMENT, PRIMARY KEY username – VARCHAR (60) password – VARCHAR (128) email – VARCHAR (255)

2. users_profiles

user_id – FOREIGN KEY refers to user_id field of user table first_name – VARCHAR(60) last_name – VARCHAR(60) mobile – VARCHAR(15)

1. SELECT all the users along with their profile details. (Hint: Use INNER JOIN)
2. SELECT the users who do not have profiles (Hint: USE LEFT JOIN and exclude the rows generated with NULL values from joining table)
3. Complete the above

Create an employee database and create a stored procedure that accepts employee_Id as input and returns complete details of employee as output.

Create two tables with the following structure

1. Authors
2. author_id – INT
3. name VARCHAR (60) titles_count INT — holds the total number numbers of titles authored
4. Titles
5. author_id – INT
6. Name VARCHAR (512) — name of the title

Perform the following operations:

1. Create a trigger to update the titles count field of respective row in authors table each time a title gets inserted into titles table.
2. Create a log table with the following structure
1. author_id – INT
2. Name VARCHAR (512) — name of the title
3. Status VARCHAR(25) — ADDITION,DELETION,UPDATION and insert an entry in that table each time the tile is added, deleted or updated. Use a trigger to accomplish this.

Create a table containing phone number, user name, address of the phone user. Write a function to search the address using phone number.

Create a table to store the salary details of the employees in a company. Declare the cursor id to contain employee number, employee name and net salary. Use cursor to update the employee.

Create a table ‘stock’ to contains the itemcode, itemname, current stock, date of last purchase. Write a stored procedure to seek for an item using itemcode and delete it, if the date of last purchase is before one year from the current date. If not, update the current stock.

For detail syllabus of all other subjects of BE Computers, M scheme do visit Computers 5th Sem syllabus for M scheme.

Dont forget to download iStudy Syllabus App for latest syllabus and results, class timetable and more.