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.

1280

std penetration resistance in very stiff clays lies bet 2 & 4 4 & 8 8 & 15 15 & 30

782

what are the standard IR values should be of R-E, Y-E, B-E, R-Y, Y-B, B-R of VCB in closed condition and in open condition for 500KVA & 1000KVA transformers. and what is the acceptable range when tested by 5000V megger.

847

HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??

374

Is sales against H Form Either in Punjab or out of Punjab treated as Zero rated sales in vat 15 form in Window showing as Break up of Zero rated sales: Direct export out of country; Sales against H Forms Or it is treated as seprate

2337

Which pipe should I use SAW, ERW or seamless if I have the following constraints I have to transport methane gas Size is 8” Corrosive environment Sulphide is present Also tell the cost comparison

674

what are the different types of optimizers?

381

explain the nature of the assembly work?

1378

What si the d/f b/w KVA & KWH, kvarh & kvar, kwh & kvar phase voltage & line voltage

4738

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

482

what is the challenging position faced in the testing not in point of management point of view it must be in the point of while testing the application?

2405

what types of testing have u done in ur project?and expalin it detail?

716

When should a company sack its auditor?

937

Tell me the SRS based review,brs based review

873

What are the upgrades happened in GRC 5.3 from GRC 5.2?

2776