Logical Modeling Design & Relational Schema

 

work on the Logical Modeling Design and to specify the entries, columns and their relationship. Use an entity-relationship ER diagram to visualize the database.

Your schema should include some attributes that make it possible to include some transactions that involve aggregate functions. For example, a school schema would allow for queries to calculate enrollment in each section of the average enrollment in courses for a given department, or the total courses being taught by each instructor, etc. This should also make interesting constraints and triggers possible. Review this basic example of a requirements document and Conceptual Data Model.

Turn your ER diagram into a normalized relational database design for the (subset of the) domain (i.e. a set of tables, each with appropriate attributes, a primary key, and appropriate foreign keys. The database should be based on the ER diagram, but one-to-one and one-to-many relationships may be implemented by appropriate attirbutes in the “one” entity, rather than as separate tables. You relational database must be at least in 3NF. Remember to determine the cardinality of the relationships. You may want to decide on cardinality when you are creating an Entity–relationship diagram ERD relatio

Sample Solution

presence of renal damage or a decreased functioning rate of glomerular.(GFR<60ml/min/1.73m2) for duration of 90 days or longerwith or without kidney damage.32 The glomerular filtration rate (GFR), which is most commonly estimated (eGFR) using equations that include serum creatinine concentration along with demographic data, is the most frequently used index of overall kidney function.33,34 This condition is frequently not associated with significant symptoms until the disease is far advanced or urinary abnormalities and is unrecognized in 80–90% of cases.35 CKD are at high risk for progress to ESRD, a condition requiring renal replacement therapy, i.e., dialysis or kidney transplantation, to keep the patient’s long-term survival.33,34 The definition of stages 1 and 2 CKD is based upon manifestations of renal damage, i.e., the presence of either micro- or macro-albuminuria, erythrocyturia, or abnormalities on renal ultrasound. Determination of the eGFR in these earlier stages is required only to differentiate between stages 1 and 2 (eGFR >90 or between 60–89 mL min−1 per 1.73 m−2 , respectively). These early stages of CKD are mostly asymptomatic i.e. the normal of kidney functions, but the possibility for advanced disease is significant. As kidney disease worsens, kidney function begins to deteriorate (stages 3 and 4 CKD). Eventually, kidney failure (stage 5 CKD) arises, and kidney replacement therapy is required. Stages 3, 4, and 5 are exclusively defined by GFR (eGFR 30–59, 15–29 or <15 ml min-1 per 1.73 m-2 respectively.)35 The K/DOQI chronic kidney disease staging system (Table 1) is based on GFR.32 Stages of CKD with their GFR values Risk factors for early chronic kidney disease: The following risk factors are associated with a significant (20–40%) risk of CRF: Obesity Hypertension Diabetes mellitus Cigarette smoking Established CVD Age > 60 years

Familial history of stage 5 CKD or hereditary kidney disease in a first or second degree relative

Severe socioeconomic disadvantage.

Presences of renal calculi (6% absolute risk)

Alcohol abuse and Benign prostatic hypertrophy.36

Most common complications and comorbidities of CRF include

Fluid and Electrolyte Abnormalities,

Anaemia,

This question has been answered.

Get Answer
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, Welcome to Compliant Papers.