i need help on how to design database sql server RRS feed

  • Question

  • hi

    i have 4 tables

    case_id int primary_key,
    rank varchar(255),
    record varchar(255)

    case_id int ,
    school_name varchar(255),
    school_name varchar(255)

    case_id int ,
    college_name varchar(255),
    college_name varchar(255)

    case_id int ,
    university_name  varchar(255),
    sub_name varchar(255)

    i want relationship of the 4 four using only case_id in  and Primary key and foregin_key

    iam using case table column(case_id ) is primary key remaing tables budget, debt and sale are in column (case id)  foriegen key usng case_id .. is design is good? or any approach best please 

    • Edited by sankaripr Sunday, September 27, 2020 5:13 PM small changes
    Sunday, September 27, 2020 5:06 PM

All replies