<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
  <!-- EF Runtime content -->
  <edmx:Runtime>
    <!-- SSDL content -->
    <edmx:StorageModels>
      <Schema Namespace="TestingModel.Store" Alias="Self" Provider="System.Data.SqlClient" ProviderManifestToken="2008" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
        <EntityContainer Name="TestingModelStoreContainer">
          <EntitySet Name="Predmet" EntityType="TestingModel.Store.Predmet" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="Ucitel" EntityType="TestingModel.Store.Ucitel" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="UctitelPredmet" EntityType="TestingModel.Store.UctitelPredmet" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="Ustav" EntityType="TestingModel.Store.Ustav" store:Type="Tables" Schema="dbo" />
          <AssociationSet Name="FK_Predmet_Katedra" Association="TestingModel.Store.FK_Predmet_Katedra">
            <End Role="Ustav" EntitySet="Ustav" />
            <End Role="Predmet" EntitySet="Predmet" />
          </AssociationSet>
          <AssociationSet Name="FK_Ucitel_Ucitel" Association="TestingModel.Store.FK_Ucitel_Ucitel">
            <End Role="Ucitel" EntitySet="Ucitel" />
            <End Role="Ucitel1" EntitySet="Ucitel" />
          </AssociationSet>
          <AssociationSet Name="FK_Ucitel_Ustav" Association="TestingModel.Store.FK_Ucitel_Ustav">
            <End Role="Ustav" EntitySet="Ustav" />
            <End Role="Ucitel" EntitySet="Ucitel" />
          </AssociationSet>
          <AssociationSet Name="FK_UctitelPredmet_Predmet" Association="TestingModel.Store.FK_UctitelPredmet_Predmet">
            <End Role="Predmet" EntitySet="Predmet" />
            <End Role="UctitelPredmet" EntitySet="UctitelPredmet" />
          </AssociationSet>
          <AssociationSet Name="FK_UctitelPredmet_Ucitel" Association="TestingModel.Store.FK_UctitelPredmet_Ucitel">
            <End Role="Ucitel" EntitySet="Ucitel" />
            <End Role="UctitelPredmet" EntitySet="UctitelPredmet" />
          </AssociationSet>
        </EntityContainer>
        <EntityType Name="Predmet">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="Nazev" Type="nvarchar" Nullable="false" MaxLength="50" />
          <Property Name="Zkratka" Type="char" Nullable="false" MaxLength="4" />
          <Property Name="PocetKreditu" Type="tinyint" Nullable="false" />
          <Property Name="Popis" Type="nvarchar(max)" Nullable="false" />
          <Property Name="UstavId" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Ucitel">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="int" Nullable="false" />
          <Property Name="Krestni" Type="nvarchar" Nullable="false" MaxLength="50" />
          <Property Name="Prijmeni" Type="nvarchar" Nullable="false" MaxLength="50" />
          <Property Name="DatumNarozeni" Type="datetime" Nullable="false" />
          <Property Name="Plat" Type="decimal" Nullable="false" />
          <Property Name="ProstredniJmeno" Type="nvarchar" MaxLength="50" />
          <Property Name="UstavId" Type="int" Nullable="false" />
          <Property Name="NadrizenyId" Type="int" />
        </EntityType>
        <EntityType Name="UctitelPredmet">
          <Key>
            <PropertyRef Name="UcitelId" />
            <PropertyRef Name="PredmetId" />
          </Key>
          <Property Name="UcitelId" Type="int" Nullable="false" />
          <Property Name="PredmetId" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Ustav">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="Nazev" Type="nvarchar" Nullable="false" MaxLength="150" />
          <Property Name="Zkratka" Type="nchar" Nullable="false" MaxLength="4" />
        </EntityType>
        <Association Name="FK_Predmet_Katedra">
          <End Role="Ustav" Type="TestingModel.Store.Ustav" Multiplicity="1" />
          <End Role="Predmet" Type="TestingModel.Store.Predmet" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Ustav">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="Predmet">
              <PropertyRef Name="UstavId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Ucitel_Ucitel">
          <End Role="Ucitel" Type="TestingModel.Store.Ucitel" Multiplicity="0..1" />
          <End Role="Ucitel1" Type="TestingModel.Store.Ucitel" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Ucitel">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="Ucitel1">
              <PropertyRef Name="NadrizenyId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Ucitel_Ustav">
          <End Role="Ustav" Type="TestingModel.Store.Ustav" Multiplicity="1" />
          <End Role="Ucitel" Type="TestingModel.Store.Ucitel" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Ustav">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="Ucitel">
              <PropertyRef Name="UstavId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_UctitelPredmet_Predmet">
          <End Role="Predmet" Type="TestingModel.Store.Predmet" Multiplicity="1" />
          <End Role="UctitelPredmet" Type="TestingModel.Store.UctitelPredmet" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Predmet">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="UctitelPredmet">
              <PropertyRef Name="PredmetId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_UctitelPredmet_Ucitel">
          <End Role="Ucitel" Type="TestingModel.Store.Ucitel" Multiplicity="1" />
          <End Role="UctitelPredmet" Type="TestingModel.Store.UctitelPredmet" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Ucitel">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="UctitelPredmet">
              <PropertyRef Name="UcitelId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
      </Schema>
    </edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="TestingModel" Alias="Self" p1:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:p1="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
        <EntityContainer Name="DatabaseEntities" p1:LazyLoadingEnabled="true">
          <EntitySet Name="Predmet" EntityType="TestingModel.Predmet" />
          <EntitySet Name="Ucitel" EntityType="TestingModel.Ucitel" />
          <EntitySet Name="Ustav" EntityType="TestingModel.Ustav" />
          <AssociationSet Name="FK_Predmet_Katedra" Association="TestingModel.FK_Predmet_Katedra">
            <End Role="Ustav" EntitySet="Ustav" />
            <End Role="Predmet" EntitySet="Predmet" />
          </AssociationSet>
          <AssociationSet Name="FK_Ucitel_Ucitel" Association="TestingModel.FK_Ucitel_Ucitel">
            <End Role="Ucitel" EntitySet="Ucitel" />
            <End Role="Ucitel1" EntitySet="Ucitel" />
          </AssociationSet>
          <AssociationSet Name="FK_Ucitel_Ustav" Association="TestingModel.FK_Ucitel_Ustav">
            <End Role="Ustav" EntitySet="Ustav" />
            <End Role="Ucitel" EntitySet="Ucitel" />
          </AssociationSet>
          <AssociationSet Name="UctitelPredmet" Association="TestingModel.UctitelPredmet">
            <End Role="Predmet" EntitySet="Predmet" />
            <End Role="Ucitel" EntitySet="Ucitel" />
          </AssociationSet>
        </EntityContainer>
        <EntityType Name="Predmet">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Int32" Nullable="false" p1:StoreGeneratedPattern="Identity" />
          <Property Name="Nazev" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
          <Property Name="Zkratka" Type="String" Nullable="false" MaxLength="4" Unicode="false" FixedLength="true" />
          <Property Name="PocetKreditu" Type="Byte" Nullable="false" />
          <Property Name="Popis" Type="String" Nullable="false" MaxLength="Max" Unicode="true" FixedLength="false" />
          <Property Name="UstavId" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Ustav" Relationship="TestingModel.FK_Predmet_Katedra" FromRole="Predmet" ToRole="Ustav" />
          <NavigationProperty Name="Ucitele" Relationship="TestingModel.UctitelPredmet" FromRole="Predmet" ToRole="Ucitel" />
        </EntityType>
        <EntityType Name="Ucitel">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Int32" Nullable="false" />
          <Property Name="Krestni" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
          <Property Name="Prijmeni" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
          <Property Name="DatumNarozeni" Type="DateTime" Nullable="false" Precision="3" />
          <Property Name="Plat" Type="Decimal" Nullable="false" Precision="18" Scale="0" />
          <Property Name="ProstredniJmeno" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
          <Property Name="UstavId" Type="Int32" Nullable="false" />
          <Property Name="NadrizenyId" Type="Int32" />
          <NavigationProperty Name="Podrizeni" Relationship="TestingModel.FK_Ucitel_Ucitel" FromRole="Ucitel" ToRole="Ucitel1" />
          <NavigationProperty Name="Nadrizeny" Relationship="TestingModel.FK_Ucitel_Ucitel" FromRole="Ucitel1" ToRole="Ucitel" />
          <NavigationProperty Name="Ustav" Relationship="TestingModel.FK_Ucitel_Ustav" FromRole="Ucitel" ToRole="Ustav" />
          <NavigationProperty Name="Predmety" Relationship="TestingModel.UctitelPredmet" FromRole="Ucitel" ToRole="Predmet" />
        </EntityType>
        <EntityType Name="Ustav">
          <Key>
            <PropertyRef Name="Id" />
          </Key>
          <Property Name="Id" Type="Int32" Nullable="false" p1:StoreGeneratedPattern="Identity" />
          <Property Name="Nazev" Type="String" Nullable="false" MaxLength="150" Unicode="true" FixedLength="false" />
          <Property Name="Zkratka" Type="String" Nullable="false" MaxLength="4" Unicode="true" FixedLength="true" />
          <NavigationProperty Name="Predmety" Relationship="TestingModel.FK_Predmet_Katedra" FromRole="Ustav" ToRole="Predmet" />
          <NavigationProperty Name="Ucitele" Relationship="TestingModel.FK_Ucitel_Ustav" FromRole="Ustav" ToRole="Ucitel" />
        </EntityType>
        <Association Name="FK_Predmet_Katedra">
          <End Role="Ustav" Type="TestingModel.Ustav" Multiplicity="1" />
          <End Role="Predmet" Type="TestingModel.Predmet" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Ustav">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="Predmet">
              <PropertyRef Name="UstavId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Ucitel_Ucitel">
          <End Role="Ucitel" Type="TestingModel.Ucitel" Multiplicity="0..1" />
          <End Role="Ucitel1" Type="TestingModel.Ucitel" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Ucitel">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="Ucitel1">
              <PropertyRef Name="NadrizenyId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Ucitel_Ustav">
          <End Role="Ustav" Type="TestingModel.Ustav" Multiplicity="1" />
          <End Role="Ucitel" Type="TestingModel.Ucitel" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Ustav">
              <PropertyRef Name="Id" />
            </Principal>
            <Dependent Role="Ucitel">
              <PropertyRef Name="UstavId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="UctitelPredmet">
          <End Role="Predmet" Type="TestingModel.Predmet" Multiplicity="*" />
          <End Role="Ucitel" Type="TestingModel.Ucitel" Multiplicity="*" />
        </Association>
      </Schema>
    </edmx:ConceptualModels>
    <!-- C-S mapping content -->
    <edmx:Mappings>
      <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
        <EntityContainerMapping StorageEntityContainer="TestingModelStoreContainer" CdmEntityContainer="DatabaseEntities">
          <EntitySetMapping Name="Predmet">
            <EntityTypeMapping TypeName="TestingModel.Predmet">
              <MappingFragment StoreEntitySet="Predmet">
                <ScalarProperty Name="Id" ColumnName="Id" />
                <ScalarProperty Name="Nazev" ColumnName="Nazev" />
                <ScalarProperty Name="Zkratka" ColumnName="Zkratka" />
                <ScalarProperty Name="PocetKreditu" ColumnName="PocetKreditu" />
                <ScalarProperty Name="Popis" ColumnName="Popis" />
                <ScalarProperty Name="UstavId" ColumnName="UstavId" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Ucitel">
            <EntityTypeMapping TypeName="TestingModel.Ucitel">
              <MappingFragment StoreEntitySet="Ucitel">
                <ScalarProperty Name="Id" ColumnName="Id" />
                <ScalarProperty Name="Krestni" ColumnName="Krestni" />
                <ScalarProperty Name="Prijmeni" ColumnName="Prijmeni" />
                <ScalarProperty Name="DatumNarozeni" ColumnName="DatumNarozeni" />
                <ScalarProperty Name="Plat" ColumnName="Plat" />
                <ScalarProperty Name="ProstredniJmeno" ColumnName="ProstredniJmeno" />
                <ScalarProperty Name="UstavId" ColumnName="UstavId" />
                <ScalarProperty Name="NadrizenyId" ColumnName="NadrizenyId" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Ustav">
            <EntityTypeMapping TypeName="TestingModel.Ustav">
              <MappingFragment StoreEntitySet="Ustav">
                <ScalarProperty Name="Id" ColumnName="Id" />
                <ScalarProperty Name="Nazev" ColumnName="Nazev" />
                <ScalarProperty Name="Zkratka" ColumnName="Zkratka" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <AssociationSetMapping Name="UctitelPredmet" TypeName="TestingModel.UctitelPredmet" StoreEntitySet="UctitelPredmet">
            <EndProperty Name="Predmet">
              <ScalarProperty Name="Id" ColumnName="PredmetId" />
            </EndProperty>
            <EndProperty Name="Ucitel">
              <ScalarProperty Name="Id" ColumnName="UcitelId" />
            </EndProperty>
          </AssociationSetMapping>
        </EntityContainerMapping>
      </Mapping>
    </edmx:Mappings>
  </edmx:Runtime>
  <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
    <Connection>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
      </DesignerInfoPropertySet>
    </Connection>
    <Options>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="ValidateOnBuild" Value="true" />
        <DesignerProperty Name="EnablePluralization" Value="True" />
        <DesignerProperty Name="IncludeForeignKeysInModel" Value="True" />
        <DesignerProperty Name="CodeGenerationStrategy" Value="Default" />
      </DesignerInfoPropertySet>
    </Options>
    <!-- Diagram content (shape and connector positions) -->
    <Diagrams></Diagrams>
  </Designer>
</edmx:Edmx>