Answer Posted /

Is This Answer Correct ?    Yes No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Blockchain is a distributed database. How does it differ from traditional databases?

5


What is the acceptable accounting procedure when an error is detected in a general ledger account? Explain why such a procedure is followed?

1590


HOW TO CALCULATE HV TEST VOLTAGE FOR ELECTRICAL EQPT.

1752


How do I make a pgadmin server?

383


What is scan table/view and seek table/view when its occurs? : sql server database administration

532






How can one estimate how the friction factor changes in heat exchanger tubes with a change in temperature?

563


What is comparator in java?

549


Explain what is sap solution manager?

1


What is the use of toarray () in java?

533


How to test multiple variables against a value?

450


Explain dialog work processes.

303


london school of science and technology has a software development unit,known as lsst solutions,which is responsible for developing and implementing software throughout the collegejames tristan keeps a record of all student details in the college including student id,name,and start date and phone number.There are many courses offered by LSST. For example MBA, MSc, BSc, BABS, DF, English etc. Each course id identified by course id, description, duration. Each course has many semesters. Each semester takes place during a particular term. Semester details and term details are required to be stored in the database. Each course has many subjects and same subject may be offered in many courses. For each subject many details such as Subject code, name, result and attendance are required to be stored. Every subject has mainly two assessments; one assignment and one exam. Assignment is worth of 30% and exam 70% respectively. You have been appointed as a database designer. Your job is to provide ERD with all possible entities and relationships. Note: Feel free to make necessary assumptions 3: Assignment Tasks. 1. Create an ERD for the above problem 2. Translate the ERD to Relational Data model (RDM) 3. Implement the RDM by creating the tables 4. Populate the database with your own data. 5. SQL Queries for the following tasks a. List all student details in each course along with course details b. Count and display number of students in each course. c. List student name, course name, assessment description, marks for all students.

2004


Explain components in angular 2?

399


What is cache in codeigniter?

314


Explain dataproviders in testng ?

517